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
624 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
513 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,179 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,209 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,173 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,577 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,494 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
593 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
653 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
512 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers