Selectively Locking Down Data - Gracefully
I have a situation where I need to retrieve the data in an encrypted column from, but don’t want to give all my users access to the symmetric key...
2015-11-18
10 reads
Blog Posts
Viewing Extended Properties for Information
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I’ve...
2015-11-18
1,492 reads
[T-SQL Tuesday] Data modeling: The trouble with prefixes
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
414 reads
[T-SQL Tuesday] Data modeling: The trouble with prefixes
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
406 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
35 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
33 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and stub tests. If you open a stored procedure in...
2015-11-17
11 reads
Enable 32 bit Applications Azure Cloud Service Hosting automation
Enable 32 bit Applications Azure Cloud Service Hosting automation
Sometime dll issues occured on IIS based on 32-bit or 64-bit dlls.Error...
2015-11-17
1,399 reads
HADR Virtual Chapter Involvement
I am always looking for ways to get involved within the PASS community. One such way that has become available...
2015-11-17
486 reads
How Client Statistics helps in improving performance in SQL Server
Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...
2015-11-17
497 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers