Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,219 reads
Blog Posts
Packt $10 Sale
One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...
2018-03-06
339 reads
Power BI Custom Visuals Class (Module 91 – Smart Filter by OKViz)
In this module you will learn how to use the Smart Filter by OKViz. The Smart Filter works similar to...
2018-03-06 (first published: 2018-02-22)
2,506 reads
Table Internal Sync Rule–Substituting the Sync Column
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-06
383 reads
Calculating DTU's for Azure SQL Database
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL...
2018-03-05
10 reads
Calculating DTU's for Azure SQL Database
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....
2018-03-05
612 reads
Capture SQL Server Reported Errors using Extended Events
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...
2018-03-05 (first published: 2018-02-20)
10,983 reads
Configure Read only routing for an always on availability group
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only...
2018-03-05
13 reads
Configure Read only routing for an always on availability group
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...
2018-03-05
641 reads
Four Ways to Find Free Space In SQL Server Database
Determine Free Space In SQL Server DatabaseIn our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using...
2018-03-05
14 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers