2015-09-08
155 reads
Editorials
NoSQL inside SQL Server
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
2015-09-07
287 reads
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
2015-09-07
307 reads
Adjusting Model
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
2015-09-04
94 reads
The Case for Upgrading
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
2015-09-03
217 reads
2015-09-02
742 reads
Software Estimates
It seems the software industry doesn't do a good job of planning and estimating software development efforts.
2015-09-01
182 reads
No More Foreign Keys?
Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.
2015-08-31
332 reads
2015-08-31
284 reads
Why Use Version Control?
Steve Jones has a story about what it's like to work with, and without, Version Control Systems.
2015-08-24
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