Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,409 reads
Blog Posts
Getting Local Books Online
One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for...
2014-05-08
891 reads
Recent Event Recap
These last few weeks have been quite a blur of projects, travel, and end-user training, and I’m enjoying every bit...
2014-05-08
735 reads
Speaking at MagicPASS on May 28, 2014
If you’re wondering who the mystery speaker is – it’s me! I’ll be doing two presentations at Magic Pass on May...
2014-05-08
341 reads
SQL Server is not a toy
I began my career working with Sybase on UNIX. Everything was done via the shell. There were strong practices in...
2014-05-08
798 reads
SQLSaturday in Houston
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
790 reads
The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,528 reads
The Importance of Networking
In a survey conducted by Business Network SW, the organization found that 87% of businesses partake in some form of...
2014-05-08
596 reads
Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
347 reads
Help - I Need a List of my Maintenance Plan Jobs *and* Schedules!
UPDATE - Jason Brimhall (blog/@sqlrnnr) pointed out after reading this post that there is a more inline way to do a...
2014-05-07
7,799 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