Speaking? You? Go on. #tsql2sday #84
This is a blog post for this month’s T-SQL Tuesday post, hosted by Andy Yun (b|t). T-SQL Tuesday is a monthly...
2016-11-08
371 reads
SQL DBA With A Beard
PowerBi and API – Visualising my Checkins
For my own amusement and also to show my wife where I have been I use the Swarm check-in app...
2016-11-03 (first published: 2016-10-29)
2,170 reads
PSConfAsia 2016
I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...
2016-10-24
521 reads
PowerShell, Pester and Ola Hallengrens Maintenance Solution
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,729 reads
The SQL Server Community Collaborative GitHub Organisation is born
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...
2016-09-14
767 reads
Converting SQL Agent Job Duration to TimeSpan using PowerShell
When you look in msdb for the SQL Agent Job duration you will find that it is an int.
This is...
2016-09-15 (first published: 2016-09-12)
1,462 reads
Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
524 reads
Remove-SQLDatabaseSafely My First Contribution to DBATools
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...
2016-07-20
989 reads
Using the new SQLServer Powershell module to get SQL Agent Job Information
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...
2016-07-14 (first published: 2016-07-03)
3,188 reads
PowerShell CMDLets added for SQL2016 Always Encrypted
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...
2016-06-30
995 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
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;
GO See possible answers