Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
495 reads
StrateSQL
Restoring Azure SQL Database to a Local Server
In last week’s post, I talked about the steps required to backup a Azure SQL Database. That post leaves us...
2013-04-29 (first published: 2013-04-23)
6,532 reads
Last Weeks Top “Reading” Links #29
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-22
1,013 reads
Reblog: April 12 to April 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-19
873 reads
Backing Up Azure SQL Database to the Cloud
When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database....
2013-04-18
1,786 reads
A Replacement for DBCC IND in SQL Server 2012
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some...
2013-05-03 (first published: 2013-04-17)
3,195 reads
Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
479 reads
Presentation Materials “What Are You Waiting For?” #SQLSat211
After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211. It was another well-received...
2013-04-13
512 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat211
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
441 reads
Reblog: April 5 to April 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-12
398 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