Select * from * : Quick Tips
What? You want to see all of your data? Well do I have the script for you! New, Improved, Extra...
2013-11-20
462 reads
Blog Posts
Speaker Idol Competition at the Hammond .NET User Group
Here's the link to download the sample scripts and meme-tastic slidedeck from my presentation "SQL Server Indexes in Your Ill-Begotten...
2013-11-20
534 reads
Testing network throughput with iperf
Have you ever wondered if that black box in your datacenter called the network is performing as well as it...
2013-11-20 (first published: 2013-11-11)
2,198 reads
Triangle SQL Server User Group Wrapup
Tonight I had the pleasure of presenting remotely to the Triangle SQL Server Users Group. I presented my session entitled “Squeezing...
2013-11-20
629 reads
Which C-level executive will be the big data champion? | ITworld
In your environment, who do you see being the Big Data champion? it probably depends on the goals of what...
2013-11-20
299 reads
Colorado SQL Events : November 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
581 reads
Colorado SQL Events : November 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
345 reads
Create video presentations
I recorded my first video presentation and demo using the screen recording and video editing software called Camtasia Studio for Windows.
It’s...
2013-11-19
586 reads
Microsoft SQL Server 2012 SP1 Cumulative Update 7
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47...
2013-11-19
2,395 reads
My favourite online references
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
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