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,792 reads
A Pattern for PIVOT
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of...
2012-07-08
2,065 reads
Identifying Long Running SQL Agent Jobs Script
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this...
2012-07-08
4,082 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,188 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,124 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
320 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,077 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
737 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,586 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
962 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers