Playing with TDE
UPDATE November 2016 – With SQL Server 2016 SP1, Microsoft will include key enterprise-class features in every edition of SQL Server...
2016-07-27
522 reads
Arun Sirpal
SQLskills Training
Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...
2016-07-12
189 reads
Azure SQL Database scripts
I thought that this would be useful for others – couple of scripts that I have been using in Azure for...
2016-07-01
185 reads
Configuring geo-replication for an Azure SQL Database
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,931 reads
sys.dm_db_wait_stats DMV
Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...
2016-06-02
240 reads
PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
168 reads
Wait Types and Latch Classes Library
Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...
2016-05-10
273 reads
SQL Server Resource Governor
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
2016-04-26
3,664 reads
Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
2016-04-21
1,718 reads
Symbols
I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...
2016-04-20
224 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers