Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
552 reads
Blog Posts
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
928 reads
Who’s using that database?
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else...
2015-03-17 (first published: 2015-03-09)
7,450 reads
“Thing IS NOT NULL” isn’t the same as “Thing != NULL”
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
577 reads
How To Speak At SQL Saturday Events
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...
2015-03-16
836 reads
Keep VM snapshot growth from wrecking your day
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...
2015-03-16 (first published: 2015-03-09)
5,229 reads
Making Sense of PCIe SSD Use with SQL Server
When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...
2015-03-16 (first published: 2015-03-10)
6,036 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-16
632 reads
Statistics on UNIQUEIDENTIFIER columns
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...
2015-03-16
1,051 reads
The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,574 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers