Some Pester Tests for SQL Defaults
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
606 reads
SQL DBA With A Beard
DBA Database scripts are on Github
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
785 reads
A Day In The Life of a SQLBits Volunteer
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
650 reads
Using PowerShell to set Extended Events Sessions to AutoStart
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,673 reads
Backing up to URL container name – case is important
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,215 reads
PowerShell Pester Testing for Parameter Validation
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,754 reads
PowerShell Pester Testing for Parameter Validation
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
713 reads
PowerShell Pester – "The script failed due to call depth overflow."
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-04 (first published: 2016-01-31)
1,693 reads
PowerShell Pester – "The script failed due to call depth overflow."
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
844 reads
Temporary Post Used For Theme Detection (7bc987a8-70ff-4bce-b0b5-d4bad4ef7912 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
441 reads
Blogs
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Using AI to Test a SQL Query
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Your SQL Starting Line: Best Free Databases for Beginners
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Forums
can ssrs detect rls and cls thru proxy like user ids?
Hi we often use non expiring windows and sql accounts to actually run (credential...
Changing the Paradigm of Work
Comments posted to this topic are about the item Changing the Paradigm of Work
Removing a File
Comments posted to this topic are about the item Removing a File
Question of the Day
Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers