Securing Database Contents with Transparent Data Encryption (TDE)
Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...
2012-07-08
7,763 reads
Blog Posts
SQL Server 2012 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-08
1,061 reads
5 Reasons Why I Need To Go To SQLskills Immersion Training
I was thinking about the contest that SQL Sentry is running for a week of SQLskills Immersion Training, and the...
2012-07-07
958 reads
Backup Master Database
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,102 reads
Basic SQL Interview Questions
We decided to add blog post that covers only basic SQL Interview questions and answers. The blog currently provides only...
2012-07-07
1,066 reads
Data Manipulation Language
In this blog post we describe what is Data Manipulation Language (DML) and include this article in our exam guide...
2012-07-07
312 reads
Lost in Translation – Deprecated System Tables – sysconstraints
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,577 reads
Lost in Translation – Deprecated System Tables – syscurconfigs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,181 reads
MDX ClosingPeriod and PeriodsToDate
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,277 reads
Speaker Selection for SQLSaturday Orlando-Group #4
We’ve selected 10 speakers so far, today we bring it to a fabulous bakers dozen with three more – all based...
2012-07-07
731 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers