2016-08-05
182 reads
All About SQL
Undocumented Commands
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
200 reads
Migrating SQL Server to Azure
There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show...
2016-08-02
219 reads
Why I like SQL Sentry Plan Explorer
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
637 reads
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
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
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
238 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
Blogs
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers