How To Get The TableDiff Utility
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables...
2013-12-05
2,574 reads
Blog Posts
Myths and Misconceptions about Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the...
2013-12-05 (first published: 2013-11-30)
4,234 reads
Power Query Preview November Update
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...
2013-12-05
1,514 reads
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...
2013-12-05
1,246 reads
SQL Server Quickie #8 – Hash Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2013-12-05
657 reads
T-SQL Tuesday #49: Topic is … Wait for It …
Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now....
2013-12-05
1,023 reads
Webcast Today: Surviving The First Week As The New DBA
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
692 reads
Colorado SQL Events : December 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-12-04
567 reads
Colorado SQL Events : December 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-12-04
311 reads
Digging Around For Free Tools – Google Code
Digging Around In Google Code
Google Code was very thin when it comes to SQL Server. I did find a few...
2013-12-04
1,091 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