Better Secure Hashing – SHA3
I’ve been giving an encryption talk over the last year, focusing on educating DBAs on the various features and capabilities...
2012-11-15
1,353 reads
How to migrate a SQL Server database to a lower version
Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...
2012-11-15
1,916 reads
"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
689 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.0: An Introduction to an Introduction
As I mentioned in my column in June, one of the many lessons I learned at the first-ever SQL Saturday...
2012-11-15
5,512 reads
Looping through multiple servers in SSIS Part 3
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,812 reads
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,166 reads
Advanced VMware certification study material reference
Gregg Robertson (b | t) has posted a fantastic page that contains a tremendous amount of information for those of you...
2012-11-15
705 reads
Quick Tip: SSIS and SAP BW
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,862 reads
My Favourites Of Paul Randal
As a new blogger, It is a little pain for me to blog on a technical topic.
It starts from learning, exprimenting, being comfortable with topic,...
2012-11-15
4,024 reads
SQL Server Version Upgrade
SQL Server Version Upgrade - You have SQL Server running nicely with no issues or problems. The trouble is its SQL...
2012-11-15
1,179 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers