Kitchen Culture
Today Andy Warren talks about an employee work item that many of you might not be tasked with.
2014-12-22
136 reads
Editorials
What counts for a DBA: Responsibility
Whose fault is it if a database is hacked and its contents appear on a hacker’s site? Louis Davidson suggests that, regardless of limitations, the DBA always bears some responsibility.
2014-12-22
155 reads
2014-12-19
107 reads
2014-12-17
584 reads
Go Small
The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.
2014-12-16
146 reads
2014-12-15
89 reads
Drop and Recreate
Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.
2014-12-15
188 reads
The Last Job
Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.
2014-12-12
151 reads
Citizen Programmers
Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.
2014-12-11
137 reads
Holiday Struggles
The sporadic schedule of a day or two a week this holiday season has been a struggle for Steve Jones.
2014-12-09
168 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