SQL Server Express with complete SSMS
Developers will love this latest improvement, specially those that have SQL Server Express installed on their laptops or workstations but...
2012-11-15
1,295 reads
Better Secure Hashing – SHA3
I’ve been giving an encryption talk over the last year, focusing on educating DBAs on the various features and capabilities...
2012-11-15
1,355 reads
How to migrate a SQL Server database to a lower version
Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...
2012-11-15
1,916 reads
"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
689 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.0: An Introduction to an Introduction
As I mentioned in my column in June, one of the many lessons I learned at the first-ever SQL Saturday...
2012-11-15
5,514 reads
Looping through multiple servers in SSIS Part 3
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,816 reads
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,169 reads
Advanced VMware certification study material reference
Gregg Robertson (b | t) has posted a fantastic page that contains a tremendous amount of information for those of you...
2012-11-15
706 reads
Quick Tip: SSIS and SAP BW
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,867 reads
My Favourites Of Paul Randal
As a new blogger, It is a little pain for me to blog on a technical topic.
It starts from learning, exprimenting, being comfortable with topic,...
2012-11-15
4,027 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
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...
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