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
619 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,170 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,003 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,168 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,565 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
508 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers