Optimize for ad hoc VS single use plans
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
364 reads
Blog Posts
Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
349 reads
Query Store Central Repository – Part 1
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across...
2019-02-20
203 reads
SQL in the City 2019 in London
We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April...
2019-02-20
777 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you do for community, whether it be volunteering, organizing, speaking,...
2019-02-20
11 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
190 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
145 reads
7 more ways to Query Always on Availability groups
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
394 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
115 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
814 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers