Buffer Pool Extensions in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-11
1,921 reads
Blog Posts
Call For Speakers for SQLSaturday Houston (Before TechEd)
SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just...
2014-03-11
396 reads
Changing the 1000 separator in Power View
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box,...
2014-03-11
1,005 reads
Don’t Park Your Vessel Here
I saw this sign recently, which at first glance is unremarkable, but I couldn’t help be amused at the inclusion...
2014-03-11
436 reads
Fight Career Frustration With Learning
If you work in IT, the office becomes your second home. It’s where we make a living, and most of...
2014-03-11 (first published: 2014-02-28)
2,963 reads
Introduction to Hadoop
Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in...
2014-03-11 (first published: 2014-02-27)
8,347 reads
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise....
2014-03-11
1,772 reads
Presenting Orlando Code Camp
I’ve been attending Orlando Code Camp for years now, and they always put on a great event. It was at...
2014-03-11
492 reads
Rails Continuous Testing
Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby...
2014-03-11
53 reads
sp_updatestats Is Not Smart
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated...
2014-03-11
1,125 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