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,022 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,748 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
850 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
908 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
37 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,098 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,669 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
850 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
847 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
6 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers