(Robert Sheldon) The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch.
Tag: sql server
SQL Server Management Studio Query Designer Shortcuts
(Babu Akkandi) While writing and editing scripts, we often try to use the keyboard as much as possible. This should be the same for SQL Server scripts as well. When using the Query Designer in SSMS there are some shortcuts that will help you be more efficient and in this tip we will take a look at a
Updating a view
(Kenneth Fisher) I was recently asked how to update views. Specifically the question was about using triggers to update a view.
Power Query Formula Language in Power BI Desktop
(Robert Sheldon) The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch.
SQL Server Management Studio Query Designer Shortcuts
(Babu Akkandi) While writing and editing scripts, we often try to use the keyboard as much as possible. This should be the same for SQL Server scripts as well. When using the Query Designer in SSMS there are some shortcuts that will help you be more efficient and in this tip we will take a look at a
Updating a view
(Kenneth Fisher) I was recently asked how to update views. Specifically the question was about using triggers to update a view.
Policy Based Management Templates – TSQL2sDay #70
(Derik Hammer) T-SQL Tuesday (aka #TSQL2sday) is a monthly SQL Server blogger event started back in late 2009 by Adam Machanic (blog | twitter). The first topic was about Date/Time Tricks.
What the MDX Axis() Function Actually Returns
(Chris Webb) A month or so ago, before I went on holiday, I was working on a really cool MDX idea that involved the Axis() function. Unfortunately I’ve forgotten what that idea was but while I was working on it I did find out something interesting about the Axis() function – namely that it doesn’t d
Extended Events Packages
(Jason Brimhall) Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects of session metadata whether the session is running or stopped. Today, I want to take a step back and look at the framework that helps give us this tool.
SQL SERVER – Identify Time Between Backups Calculation
(Pinal Dave) As part of my script archives, I stumbled upon a script that I had written a long time back and thought this must get to the blog. This script was inspired from a simple question asked by an DBA when I had visited them for a session.
