Using the PowerShell AST to find a ForEach Method
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
315 reads
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
315 reads
Photo by Farrel Nobel on Unsplash
Welcome to another edition of T-SQL Tuesday!
This T-SQL Tuesday is hosted by Wayne Sheffield ( blog | twitter ) and he has asked...
2018-08-14
218 reads
I like to write Pester checks to make sure that all is as expected! This is just a quick post...
2018-07-25
1,210 reads
in my last post I showed how you can save the results of dbachecks to a database and created a...
2018-06-07 (first published: 2018-05-28)
1,856 reads
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,043 reads
With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...
2018-05-25 (first published: 2018-05-19)
2,360 reads
There was an announcement on the Visual Studio Code blog about the public preview of Live Share. This enables you...
2018-05-17 (first published: 2018-05-08)
2,063 reads
I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences....
2018-05-15
316 reads
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want...
2018-05-10
349 reads
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
228 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers