Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
992 reads
Blog Posts
Increasing and decreasing the performance level of your Azure SQL Database
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
732 reads
Microsoft database migration tools
There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17):
Data Migration Assistant (DMA)...
2017-03-29
1,127 reads
Power BI Custom Visuals Class (Module 44 – Attribute Slicer)
In this module you will learn how to use the Attribute Slicer Power BI Custom Visual. Using the Attribute Slicer...
2017-03-29
1,157 reads
Random Blogging Challenge Results
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
649 reads
Restoring an entire SQL Server user databases with PowerShell using dbatools
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,060 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Orange County)
on Apr 1st 1.30 pm, I will be presenting “consolidated essential performance health check using powershell” @ sqlsaturday, Orange County, if...
2017-03-29
451 reads
SQL Server Query Store
Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...
2017-03-29 (first published: 2017-03-13)
6,381 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,256 reads
Trouble Shooting Little Jewel
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
711 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers