T-SQL Tuesday #102: Giving Back
Last month we had the opportunity to discuss some of the most important tools for a data professional. I took...
2018-05-09
283 reads
SQL RNNR
T-SQL Tuesday #102: Giving Back
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
Change SQL Server Collation – Back to Basics
One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment...
2018-04-19 (first published: 2018-04-12)
2,736 reads
Change SQL Server Collation – Back to Basics
Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire...
2018-04-12
108 reads
T-SQL Tuesday #101: Essential Tools
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools...
2018-04-10
366 reads
T-SQL Tuesday #101: Essential Tools
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the...
2018-04-10
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system...
2018-04-17 (first published: 2018-04-06)
3,915 reads
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...
2018-04-06
65 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...
2018-04-01
400 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...
2018-04-01
8 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
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