Review: Windows Live Writer Backup
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
Blog Posts
SQL Developers Please Use the Table Name/Alias to Prefix Columns
Note: After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself...
2010-02-16
871 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,845 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,557 reads
The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-16
3,476 reads
Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,119 reads
Finding Blog Topics
I used to think that I would run out of things to write about, but a decade after starting to...
2010-02-15
877 reads
First Public Hearing Against Quebec's Pension Fund Manager - The Beginning of Proof that Multiple Laws Were Violated (Before Sabia took over at least)
As mentioned in a previous post, between the months of January and September 2008 I was hired to be a Database...
2010-02-15
7,513 reads
nHibernate Database, First Look
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,292 reads
Set your Warehouse Database to Read Only
In most environments new data is added to the data warehouse daily, weekly or even monthly.Even further, these changes typically...
2010-02-15
726 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers