MySQL TinyInt treated as Boolean
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the...
2015-04-29
2,900 reads
Blog Posts
Outlier Detection with SQL Server, part 6.2: Finding Outliers Visually with Reporting Services Box Plots
By Steve Bolton
…………Throughout this series of amateur mistutorials in using SQL Server to identify outliers, we have repeatedly seen that...
2015-04-29
2,457 reads
Rebuild Indexes of database with fragmentation more than 30%
Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application...
2015-04-29 (first published: 2015-04-18)
17,743 reads
Running Powershell scripts remotely.
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...
2015-04-29
1,607 reads
They Can Do What? – SHUTDOWN - WaterOx Consulting
Reading Time: 1 minutesMany times the DBA is faced with the dilemma of granting excessive...
The post They Can Do What?...
2015-04-29
987 reads
Tracking Table Usage and Identifying Unused Objects
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...
2015-04-29 (first published: 2015-04-20)
16,914 reads
Using SSIS Lookup Transformation in ETL Packages
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of...
2015-04-29
17,894 reads
Clustered Columnstore Indexes – part 52 (“What’s new for Columnstore XE in SQL Server 2014 SP1”)
Continuation from the previous 51 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Microsoft has launched Service Pack 1 for...
2015-04-28
488 reads
Exam Prep 70-463: Master Data Services Models
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-28 (first published: 2015-04-16)
5,347 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our...
2015-04-28
30 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers