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
525 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
192 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
188 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,941 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
248 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
172 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
276 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,711 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,730 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
227 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers