How to remove additional (unwanted) log files
Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...
2014-11-05
1,235 reads
Kenneth Fisher
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures....
2014-11-03 (first published: 2014-10-22)
6,575 reads
My DTS Package won’t load with the error “here were errors loading package”
You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...
2014-11-03
784 reads
Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,821 reads
Update to “The clustered index columns are in all of the non clustered indexes.”
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...
2014-10-29 (first published: 2014-10-20)
6,081 reads
A script to list the DTS connection information for every package on the instance.
For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...
2014-10-27
670 reads
UNION vs UNION ALL
You might be wondering why I’m going into such a simple subject. Well the way I see it there are...
2014-10-16
2,758 reads
TSQL Tuesday #59: My Hero, My Inspiration, My Wife
TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...
2014-10-14
1,163 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,198 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,301 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kontak Bank BCA KCP Cimahi Telp:08218154392
WA CS:083178278662 Jl. Raya Cimahi No.533, Karangmekar, Kec. Cimahi Tengah, Kota Cimahi, Jawa Barat...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers