Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012
Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...
2012-07-03
5,421 reads
Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,422 reads
SSIS SCD vs MERGE Statement – Performance Comparison
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,701 reads
SQL Server 2008 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-03
1,367 reads
Speaker Selection for SQLSaturday Orlando-Group #4
Ten speakers selected, and as we go into the July 4th holiday we’re going to add two more to that...
2012-07-03
321 reads
SQL Server Auditing – Getting started
In my organization, one of my jobs is auditing our database environment. I’ve been tasked with this responsibility for several...
2012-07-03
1,865 reads
July 2012 – Monthly SQL Server Checklist
The year is half over and for many of us, specifically those in the United States, it’s a tricky week...
2012-07-03
894 reads
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,273 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
631 reads
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
395 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Optimized Locking in SQL Server 2025
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers