Do We Understand Data?
With the recent issue of Facebook/Cambridge Analytica and GDPR, I ask do we really understand "data"?
2018-06-01
86 reads
Scott Crosby
The Politics of SQL Security
Dealing with SQL Server security when the application it uses is full of security holes.
2016-05-23
158 reads
Getting It Right First Time. Almost?
Mistakes happen but how can we minimize them and deal with them whey they do happen?
2014-08-05
161 reads
Wandering Towards The Lonely Cloud?
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
79 reads
Blogs
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Top Azure Synapse Analytics and Power BI questions
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Forums
ROWLOCK UPDLOCK - Locks whole table
Hi All I came across the following query on one of my systems. SELECT...
Index scan
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
why cannot use ClientProcessID to trace data in SQL Server Profile.
A C/S system is running on a SQL Server database, and I get its...
Ask SSC