Test your UPDATEs and DELETEs before you run them
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...
2015-02-18
2,237 reads
Blog Posts
T-SQL Tuesday #63 - Managing Security - Enforce SQL Login Policies
Today, February 10, 2015 is TSQL
Tuesday, no.63! (Click on the highlighted link for the Invitation.)
Hosted this month, by Student of...
2015-02-18 (first published: 2015-02-10)
10,503 reads
T-SQL Tuesday #63: How do you manage security
This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.
Security is one of...
2015-02-18 (first published: 2015-02-10)
6,690 reads
VMware vExpert 2015
VMware has announced the list of 2015 recipients of the vExpert award, and I am humbled and honored to have been...
2015-02-18
378 reads
Enough Is Enough! Why Do We Have To Be At Risk?
Reading Time: 2 minutes
When Do We Say Enough Is Enough?
Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information...
2015-02-17 (first published: 2015-02-07)
7,935 reads
Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help it. And there is even plenty of metadata within...
2015-02-17
11 reads
Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help...
2015-02-17
2,054 reads
Q and A With SQL MVP Chris Shaw
This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...
2015-02-17
962 reads
SQL Code Guard v2.7 released
Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...
2015-02-17
1,587 reads
The Vacation Conundrum
Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...
2015-02-17
879 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers