5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
115 reads
Blog Posts
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
4 reads
Event-driven architecture (EDA) with Azure Data Factory - Triggers made easy
(2019-Oct-27) Creation or deletion files in your Azure Storage account may initiate data ingestion process and will support your event-driven data platform architecture. Image by Lars_Nissen_Photoart from PixabayMicrosoft recently introduced an...
2019-11-05 (first published: 2019-10-28)
806 reads
Every Execution Plan Is An Estimated Plan
I consider myself to be the most responsible for making such a huge deal about the differences between what is labeled as an Estimated Plan and an Actual Plan....
2019-11-05 (first published: 2019-10-22)
517 reads
MS Ignite Day#1 Recap
What an amazing first day at Microsoft Ignite that all started at about 6:30 this morning when I got in line to be one of the first 3000...
2019-11-05
95 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
34 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
12 reads
Smart Tlog Bkp
another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the...
2019-11-05
20 reads
Speaking at PASS Summit 2019
As I announced before, I had the honor to be selected as speaker for PASS Summit this year. This is a huge deal for me as data professional and...
2019-11-05
17 reads
SQL Server 2019 GA
Yes, Finally SQL Server 2019 is Generally Available yesterday Nov 4th 2019. It has many great features great videos: https://channel9.msdn.com/Niners/dutchdatadude https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/ https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/
2019-11-05
86 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers