Quick Script: Index Sizes
In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither...
2015-08-13
722 reads
Blog Posts
Reblog: Slow source? Make your data flow buffers smaller!
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...
2015-08-13
806 reads
SSIS Catalog – Path to backup file could not be determined
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...
2015-08-13 (first published: 2015-08-10)
4,851 reads
SSMS 2016 CTP 2.2 Setup Failure 0x81f40001
I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). ...
2015-08-13
1,683 reads
Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
433 reads
Columnstore Indexes – part 62 (“Row Groups Trimming”)
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
573 reads
Farewell Scott McKenzie
Scott McKenzie was the DJ of Mix 105 here in Orlando for an astounding 24 years and that’s been the...
2015-08-12
638 reads
Hadoop and Microsoft
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of...
2015-08-12
3,195 reads
Here’s the New #Excel 2016 Chart Types!
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,164 reads
How easy or difficult to write dynamic SQL ? TIP#110
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...
2015-08-12
1,289 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
SQL Server Automated Backup & SAN Replication Solution
Comments posted to this topic are about the item SQL Server Automated Backup &...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers