Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
743 reads
Tim Radney - Database Professional
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
429 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
883 reads
SQL Saturday #89 Atlanta GA
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered...
2011-06-15
509 reads
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,384 reads
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,138 reads
SQL Saturday 74 – Jacksonville FL
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...
2011-05-02
888 reads
SQL Community Support
I have blogged before about my appreciation for the SQL community mainly within the PASS organization as that is what...
2011-04-25
544 reads
If you truly want to understand something try and change it.
I saw this quote on facebook last week and it really hit close to home. I had just started working...
2011-04-11
694 reads
SQL Saturday #70
This blog is long overdue about my journey to Columbia SC for SQL Saturday #70. I was very fortunate to...
2011-04-07
428 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