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
5 reads
Blog Posts
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,754 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
856 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
913 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,101 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
39 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,690 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
854 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
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 tell that the keynote was on… I mean...
2015-10-29
9 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers