Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
620 reads
Gethyn Ellis
Are Transaction Rolled Back When CHECKDB Runs?
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks...
2010-05-12
509 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,172 reads
SQL Server Replication - Replication Agents
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,020 reads
When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,169 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,567 reads
SQL Server Replication Overview
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,464 reads
Microsoft Teleconference – Ted Kummert (Senior VP) and Tom Casey (General Manager of BI)
Microsoft held a big teleconference today, which I unfortunately got called away from a minutes into it. The call was...
2010-04-21
590 reads
Virtualisation – An Introduction
For the last two years or so, in one capacity or another I have been running SQL Server in virtual...
2010-04-21
649 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
509 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
restore db as db_copy. resolve hardcoded references within procedures to db.
So I backup & restore db as db_copy. within both there is a proc...
Transpose sql table rows into columns
I want to transpose sql table rows to columns. I have written a query...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers