Data Masking for Convenience
Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.
2015-09-24
134 reads
Editorials
Everyone is a Target
Today Steve Jones looks at the targeted attacks by hackers against individual security professionals.
2015-09-23
121 reads
Data Sprawl
The challenges of data growth and sprawl can be compounded by the variety of tools and platforms available. Steve Jones notes that you might need to learn a bit about different technologies.
2015-09-22
128 reads
Data Liability
The issue of who owns data, and who is responsible is one that our world hasn't defined well. Steve Jones has a few thoughts on potential issues for data professionals.
2015-09-21
114 reads
Whatever happened to Database Table Refactoring?
Phil Factor ponders why most people lost their initial enthusiasm for refactoring databases iteratively, in parallel with the evolutionary design of the rest of the system.
2015-09-21
178 reads
2015-09-16
306 reads
Who's a Good Developer?
Is there a way to tell who the good developers are? Steve Jones has a few thoughts on why this is an issue.
2015-09-15
297 reads
2015-09-14
135 reads
2015-09-11
251 reads
2015-09-10
281 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