Speaking at SQL Saturday 122 - Louisville
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
867 reads
Blog Posts
SQL Audit 101 – Creating a basic audit
SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...
2012-07-09
2,387 reads
SQL Internals Reading Data Records Part 6: Variable Length Data
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,203 reads
Writing About SQL Server
I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...
2012-07-09
1,425 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,052 reads
Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...
2012-07-08
1,474 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,074 reads
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
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
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers