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
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
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
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
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
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
Artikel „SQL Server 2014 – Neues Fundament“ in iX Ausgabe 5/2014, Richtigstellungen zu In-Memory OLTP und ColumnStore Indexes und warum AlwaysOn nicht gleich Always On ist
Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014, corrections in In-Memory OLTP and ColumnStore Indexes, and why AlwaysOn...
2014-05-08
1,233 reads
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,187 reads
Secure Coding
I was looking recently for some sort of guideline that would help me ensure that code was securely written. I...
2014-05-07
841 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
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...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers