Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
647 reads
StrateSQL
Last Weeks Top 10 “Reading” Links #21
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-25
998 reads
Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
907 reads
Five Virtual Labs for the SQL Server 2012 DBA
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them...
2013-03-01 (first published: 2013-02-21)
4,257 reads
Presentation Materials “What Are You Waiting For?”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
561 reads
Calculate Bitmasks In PowerShell
Have you ever had to calculate bitmasks on the fly? I have and still do. In this post, I’m going to show...
2013-02-19
1,637 reads
Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works
Ever have your SQL Server slow down for reasons that you can’t explain? Or did you spend all night tuning...
2013-02-18
570 reads
Last Weeks Top 20 “Reading” Links #20
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-18
589 reads
Reblog: February 8 to February 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
886 reads
Start Getting Ready for PASS Summit 2013
Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit. There...
2013-02-14
681 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers