Checking for Excessive Permissions in SQL Server - Syndication – WaterOx Consulting
Who can do what? One of the key things that a DBA...
The post Checking for Excessive Permissions in SQL Server...
2015-09-02
512 reads
Blog Posts
Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...
2015-09-02
628 reads
Learning Regular Expressions
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
962 reads
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
657 reads
Nominated for Author of the Year 2015
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award...
2015-09-02
413 reads
Pro SQL Server Wait Statistics available now!
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,565 reads
Stock Market Chart in Power BI
U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...
2015-09-02 (first published: 2015-08-24)
3,546 reads
Targeted Plan Cache Removal
A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...
2015-09-02 (first published: 2015-08-24)
1,587 reads
Upcoming Presentation – Space Coast SQL/.Net User Group
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to...
2015-09-02
1,110 reads
Viewing Deployed XEvent Metadata
When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events....
2015-09-02
11 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers