PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
Getting Started with Data Bars in SQL Server 2008 R2 Reporting Services
I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
Strike Force
Would you want to be part of a Strike Force or "A-Team" in IT? Steve Jones thinks most of us would rather just do a good job and go home.
The Twelve Days of (SQL) Christmas
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
Resolve to Plan Your Year
Today we have a guest editorial from Andy Warren that asks you to look forward to the next year and think about your future.
Slipstreaming SP\CU During Setup
This article shows how to slipstream the SP and CU during the SQL Server setup process.
The Professional Student
This week Steve Jones talks about the need for people working in technology to be professional students. Get a few ideas of what you can learn this week from Database Weekly.
TSQL Challenge 46 - Remove leading occurrences of the first character
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers