Test your Sqlserver backups on Linux with PowerShell and dbatools
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...
2017-03-27
352 reads
Blog Posts
Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
799 reads
The Public Speaking Roadmap
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like....
2017-03-25
341 reads
A Note on Configuring HP SSD’s
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage...
2017-03-24
435 reads
Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”
This blog post is a form of resolution to the issue of not being able to shrink a transaction log...
2017-03-24
234 reads
Is Your Data Open to Abuse? T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,890 reads
The $650 SQL Saturday
SQL Saturday #596 – Denver BI Edition was held on Feb 25, 2017. In keeping with my idea for a slimmer...
2017-03-24 (first published: 2017-03-07)
2,208 reads
TSQLTuesday.com – Quick WordPress Setup in Azure
When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting...
2017-03-24
1,135 reads
Why did my SQL Server database just go offline?
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
386 reads
An Introduction to Conatiners and Docker: Switch to Windows Containers
This is Chris Gibson's second post. This post follows on from his first post called: An Introduction to Containers and...
2017-03-23
1,010 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