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,620 reads
Blog Posts
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
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
Friday Reading 2017-03-31
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
573 reads
Friday Reading 2017-03-31
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
421 reads
Global v Session Trace Flags
I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss...
2017-03-31 (first published: 2017-03-16)
1,942 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
629 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
579 reads
SQL 2016 – Clone Database with Query Store
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016...
2017-03-31 (first published: 2017-03-20)
2,368 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
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers