Monthly profit percentage techniques
Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...
2013-10-30
2,003 reads
Blog Posts
Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,220 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,371 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
8 reads
A look at comments
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...
2013-10-29 (first published: 2013-10-21)
1,761 reads
Interview FAQ on Interface in C#
What is Interface?
An interface is collection of methods, properties, indexers and events with only signatures. Means In interface Methods, properties,...
2013-10-29
1,587 reads
My First Book: SQL Server 2012 Reporting Services Blueprints
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,305 reads
PASS Summit 2013
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I...
2013-10-29
1,131 reads
Query Tuning in Dallas
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
678 reads
sp_BackupDatabases v1.2
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,625 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