An Exit Becomes the Next Entrance
If you live life in the manner that I do, life is all about change and self-improvement. To me, life...
2013-09-03
795 reads
Blog Posts
Backup Your Certificate for TDE
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...
2013-09-03 (first published: 2013-08-26)
1,874 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...
2013-09-03
916 reads
Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-09-03
2,044 reads
Duplicate Statistics
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,528 reads
Introduction to Integrity: Interpreting DBCC CHECKDB Results
I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most...
2013-09-03
955 reads
Last Weeks Top “Reading” Links #47
It’s Tuesday, it’s time for weekly round-up #47. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-09-03
1,021 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
547 reads
Retiring of the MCM Certifications, Part II
Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...
2013-09-03
1,348 reads
SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases
Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script.
You just need to run the...
2013-09-03
1,647 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers