Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
482 reads
Blog Posts
TDE and Availability Groups
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
671 reads
You DO have outstanding, free backup and maintenance, right?
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
664 reads
Calculate Percentage Share in Power BI (DAX)
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,929 reads
Extended Event Management Power Tools
So far in this series I have introduced a couple of tools that are suitable for helping with the management...
2015-10-06
621 reads
Extended Event Management Power Tools
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...
2015-10-06
4 reads
How I Got my Start at Pragmatic Works
October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a...
2015-10-06
559 reads
Intro to the Social DBA with a bit of #SQLHelp
Are you a Social DBA?
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...
2015-10-06 (first published: 2015-09-28)
2,492 reads
Load Testing Your Storage Subsystem with Diskspd – Part III
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results....
2015-10-06
5 reads
New Article: Loading Fixed Width Files to Staging Tables
My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...
2015-10-06
652 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