Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week!
Some of you may have noticed that I’ve...
2013-08-09
1,245 reads
SQL Server Diagnostic Information Queries for August 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-08-19 (first published: 2013-08-09)
3,621 reads
Disaster Recovery Docs–Offsite
Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything...
2013-08-16 (first published: 2013-08-08)
2,315 reads
How implicit data type conversion slows down your query
Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But...
2013-08-08
1,487 reads
Best Practices to Deliver BI Solutions
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need...
2013-08-08
1,530 reads
Survey: Are you a SQL Server Professional and running on Mac?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...
2013-08-08
1,156 reads
Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)
My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch...
2013-09-06 (first published: 2013-08-08)
1,028 reads
Connecting to the Hortonworks Sandbox v1.3 through IP 192.168.56.101
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface...
2013-08-08
1,661 reads
Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time...
2013-08-08
968 reads
Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
553 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
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
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
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