SQLBits XI recently announced
When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply...
2012-11-14
834 reads
problem solving: sometimes you need to walk away from a problem to solve it
If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and...
2012-11-14
726 reads
SQL PASS Summit 2012 Came and Went – and Changed My Life
I cannot believe how surreal this past SQL PASS Summit was for me. This was the second Summit I have...
2012-11-20 (first published: 2012-11-14)
1,958 reads
Remote Desktop and Surface
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,371 reads
SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
919 reads
Database Mirroring Performance Counters
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t...
2012-11-21 (first published: 2012-11-14)
2,729 reads
SQL Server Virtualisation
SQL Server Virtualisation - Lots of companies and organisations are adopting a virtualisation first approach to the installation of new servers...
2012-11-14
786 reads
SQL Server || Compress & UnComprees Backups in one Media\File
Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File.
Query No. 1
BACKUP...
2012-11-14
2,505 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
9 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
17 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