Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,868 reads
Blog Posts
Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs
I writing this blog post as a result of the following two questions, which I’ve been asked by one of...
2014-04-04
2,182 reads
Don’t Be an Arse
In deference to my British employers, I’ll use their word.
It constantly strikes me how rude, stupid, and unfriendly people can...
2014-04-04
986 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
504 reads
Friday Followup For April 4, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-04
477 reads
Great Companies – Spotify
I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this...
2014-04-04
696 reads
Monthly Reflections – March 2014
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...
2014-04-04
677 reads
New Extended Events for Tracing in SQL Server 2014
Neue “Erweiterte Ereignisse” (XEvents) für Tracing in SQL Server 2014
(de)
Dieser Artikel enthält eine Liste der neuen Erweiterte Ereignisse (“Extended Events”),...
2014-04-04
3,060 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
605 reads
5 Tools Every DBA Should Know About
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,358 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
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
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
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