SQL Server 2012 (“Denali”): AlwaysOn
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters...
2011-12-21
1,579 reads
Explaining SQLSaturday
I wrote a while back about my coffee cup from SQLSaturday #100. I took it to work (where I usually...
2011-12-21
641 reads
VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,405 reads
Routing OSPF and Network Team
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
665 reads
2011 PASS Board Elections Notes
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
953 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
514 reads
Modifying SQL Server Synonyms
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,409 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
659 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
915 reads
Full Load. Incremental Load. Whaaat?
Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...
2011-12-20
6,721 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