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
771 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,062 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
827 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,489 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
801 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,362 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,736 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,266 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,083 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
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers