Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
8 reads
Blog Posts
Tricks and Treats with XE
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,024 reads
A Basic Introduction of Database, Tables and SQL.
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-29 (first published: 2015-10-20)
2,757 reads
Columnstore Indexes – part 70 (“Filtered Indexes in Action”)
Continuation from the previous 69 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is the continuation from...
2015-10-29
858 reads
Columnstore Indexes – part 71 (“Change Data Capture, Change Tracking & Temporal”)
Continuation from the previous 70 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In the SQL Server world of data...
2015-10-29
916 reads
Default Sessions
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
42 reads
Default Sessions
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,106 reads
Generating scripts for previous versions of SQL
I make a habit of using the latest version of SSMS even if I’m not working with the latest version...
2015-10-29 (first published: 2015-10-21)
1,696 reads
My PASS Summit 2015 Presentation
I’m going to present my session about working with parameters in PASS Summit on Thursday at 03:15pm. The title of...
2015-10-29
856 reads
PASS 2015 Session Report – KeyNote and SQL Server on Azure Virtual Machines: Features, Best Practices & Roadmap
So PASS officially kicked off this morning leading into the next 3 days of back to back sessions.
You could certainly...
2015-10-29
856 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