SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
377 reads
Max Length of a column in a DataTable in PowerShell
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...
2017-04-01
1,621 reads
April Fools 2017
Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny...
2017-04-01
508 reads
Why I’m Changing to MySQLAndy
From time to time we all have to examine our path and decide if we need to make adjustments. Looking...
2017-04-01
427 reads
How to grow the exposure of a Data Platform based conference (SQL Saturday South Island)
SQL Saturday conferences are awesome.
That is the opening line of this blog post – because it’s true and understated.
If you’re reading...
2017-04-01
236 reads
Speaking on Re-Indexing – The quest of ultimate automation – SQLSaturday (Orange County)
Apr 1st 2.45 pm, I will be presenting “Re-Indexing – The quest of ultimate automation” @ sqlsaturday, Orange County, if you are...
2017-03-31
581 reads
SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,522 reads
Thoughts on PASS Summit Speaker Selection Changes
Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from...
2017-03-31
813 reads
SSIS Catalog Logging Tables
Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging...
2017-03-31
890 reads
Notes from the March 2017 MagicPASS Meeting
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
630 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers