Re-blog – December 9 – December 15
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-16
614 reads
Why Am I Amazed By a 2000 Page Word Doc?
It’s not uncommon to have information shared in a Word doc, but I was surprised recently to open one up...
2011-12-16
734 reads
The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine
If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...
2011-12-16
36,935 reads
Counting Merge Replication Article Changes
One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...
2011-12-16
2,045 reads
Why did I start blogging?
This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....
2011-12-16
692 reads
PASS Summit 2011 Session Evaluations
Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...
2011-12-15
1,084 reads
Why Do I Blog? #meme15
As I mentioned in a post last week, a new meme has been born. This one is dedicated to discussing...
2011-12-19 (first published: 2011-12-15)
1,559 reads
Why I Blog – #Meme15
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
574 reads
How many times the T-SQL inside the CTE is executed?
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2011-12-19 (first published: 2011-12-15)
11,574 reads
How to change the SQL Server service account
It’s easy. First you click here:
Then you find the SQL Server 2008 or 2008 R2 program group
Open those and then...
2011-12-15
21,849 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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...
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