Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,627 reads
SQL Server 2005 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-08-23
1,105 reads
Transparent Data Encryption (TDE) with Database Mirroring
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,751 reads
Tips For Minimizing Deadlocks in SQL Server
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,489 reads
Amazing Margaritas in Austin – SQL in the City US Tour
The last time I was in Austin was last year, for a weekend trip with my wife to see Stevie...
2012-08-23
1,482 reads
Learning about Driving with Big Data
This is nice, a year long safety pilot from the University of Michigan. Quite extensive, using 3,000 cars to gather...
2012-08-23
804 reads
Microsoft Store vs Apple Store
Yesterday I went to the new Microsoft store at Florida Mall, mostly out of curiosity and something to do at...
2012-08-23
815 reads
Don't Disconnect Your Common Sense
This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...
2012-08-23
1,761 reads
Paying it Forward
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...
2012-08-24 (first published: 2012-08-22)
1,748 reads
Lost in Translation – Deprecated System Tables – sysdepends
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-08-22
1,236 reads
Blogs
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....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers