Managing SQL Servers With Policy Based Management
Policy Based Management has been in SQL Server since 2008 and allows you to define policies that can report issues...
2018-05-16
93 reads
Blog Posts
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
111 reads
Removing servers from the SSMS connection dialog (Day 36)
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
1,845 reads
See you at SQLSat Dallas!
Looking forward to making the road trip on Friday and joining the #SQLFamily at SQLSat Dallas 2018 this Saturday. It's my first SQLSat Dallas since my last trip to...
2018-05-16
10 reads
Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)
We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years...
2018-05-16
353 reads
The trials and tribulations of REVERTing from impersonation
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
379 reads
Thoughts on the 2018 (and beyond) PASS Elections – Part 1
Last week Wendy Pastrick of the PASS Board posted PASS Election 2018 Timeline. It’s a good post for a few...
2018-05-16
319 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed...
2018-05-16
15 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2....
2018-05-16
381 reads
When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,589 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers