So Long Seattle and Thanks for all the Fish!
I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high...
2015-10-25
567 reads
Blog Posts
Counting Events
This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...
2015-10-23
9 reads
Counting Events
After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...
2015-10-23
596 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,854 reads
First Day as DBA - Now What?
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,209 reads
Improved #MinionBackup and #MinionReindex – new versions!
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
667 reads
PASS Summit 2015 Plans
I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...
2015-10-23
581 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
622 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
412 reads
SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
640 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