Central Subscriber Model Explained
The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single...
2013-01-28
2,078 reads
Bananas For SQLSaturday
I was catching up on reading today and saw that Instructables had a how-to on “tattooing” a banana, also called...
2013-01-28
910 reads
Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC
The end of the day is quickly approaching as I finish this blog post. This is day 22 in my...
2013-01-27
1,440 reads
Windows 8 In 25 Minutes
Here’s a quick plug for The Missing Windows 8 Instructional Video. I watched it and learned quite a few things,...
2013-01-27
743 reads
Speaking at VMware Partner Exchange on February 24
I am pleased to announce that I am speaking at VMware’s Partner Exchange for their CI1464 – Virtualizing Microsoft SQL Server...
2013-01-26
796 reads
Day 21 of 31 Days of Disaster Recovery: Who Deleted That Data?
Welcome back for day 21 of my 31 Days of Disaster Recovery series. Today I want to talk about trying...
2013-01-26
1,519 reads
Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !
The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all...
2013-01-26
1,103 reads
SQL Server 2008 Service Pack 3 Cumulative Update 9
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect...
2013-01-25
1,578 reads
Type 2 SCD with SQL Merge
I was going through some notes I had from previous projects and came across a sample script for created a...
2013-01-25
10,703 reads
Reblog: January 18 to January 24
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-25
1,056 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers