Getting Started with Power BI: Getting Data (Part 2 of 3)
This is part 2 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-09
172 reads
Blog Posts
Monitoring SLAs with SQL Monitor Reporting
Proactive Reporting for SQL Server
If you’re a return reader of this blog you know I write often about monitoring and...
2017-02-09 (first published: 2017-02-04)
2,048 reads
Opening the PowerShell ISE from Explorer
This is a cool productivity trip, and one that I ran into by accident. I had heard that I could...
2017-02-09
1,726 reads
Speaking at Triad Developer’s Conference
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
362 reads
SQL: Different ways to generate sequence
There was a question from the op regarding adding a new column to a query output by generating the cyclic...
2017-02-09 (first published: 2017-02-06)
2,515 reads
How many times the T-SQL inside the CTE is executed?
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2017-02-08 (first published: 2011-12-15)
11,565 reads
How the SQL Agent Job schedule_uid broke my heart, and my jobs!
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-08 (first published: 2017-02-03)
9,431 reads
IoT Hub vs. Event Hub
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...
2017-02-08
334 reads
Let NonAdmins Get Logins
I saw a question recently about how to allow some users to see the logins on a server without being...
2017-02-08
826 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow,...
2017-02-08
308 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers