SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
774 reads
How To Win Career Gold
The start of a new working year is often a time for self reflection. This is a great thing, it’s...
2013-01-22
1,065 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
831 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,493 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
806 reads
sp_PerformanceCounters - Get a Health Check of SQL Server's Performance
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,364 reads
Power View Matrix Drill Capabilities
The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the...
2013-01-21
3,739 reads
Full-Text Search – Thesaurus
I would hope that most of us have used a thesaurus at some point in our careers. These allow us...
2013-01-25 (first published: 2013-01-21)
5,267 reads
How Do You Query Maintenance Plan Package Metadata?
Hello Dear Reader! Since I’ve joined Pragmatic Works I’ve learned a lot, seen a lot, and assisted in interviewing a...
2013-01-23 (first published: 2013-01-21)
5,084 reads
SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...
2013-01-21
762 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