Looking for sp_whoisactive?
A while ago I quietly announced the new home for sp_whoisactive, whoisactive.com . Today I finished migrating all related content — including the documentation consisting of a series of 28 articles posted on this blog a while back. So if you’re lookin …
SQL-On-Hadoop: Hive – Part I
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation
While preparing for a demo for an upcoming session, I came across an error which I didn’t see earlier. Here is the error in the UI and it is related to Backup Log Operation. I am also trying to add a file to the database using below command. USE …
Let’s Corrupt a Database Together, Part 3: Detecting Corruption
So far in this series, I’ve shown you how to corrupt a clustered index, then how nonclustered indexes can be corrupted independently. If you haven’t read those, you should start there first. Let’s start again with our 50Ways database, …
Containers for enhanced Data Governance and Compliance
Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.
Azure DWH part 12: Permissions, roles, logins and users
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
SQL SERVER – FIX: Msg 35250 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed
Earlier I wrote a blog on same error message which you can read from below link. SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed One of my blog reade …
Danger Averted: A DBA Horror Story
Most technical articles written explore new features of existing products or identifying a problem and providing a solution. read more
Scenic City Summit is this Friday
Scenic City Summit is a one day conference in Chattanooga, the Scenic City Summit is a new experience for me, although in a familiar, Devlink-esqe setting of the Chattanooga Convention Center in Chattanooga, TN. I am looking forward to attending, and s …
[Video] Office Hours 2017/07/19 (With Transcriptions)
This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, and more… Here’s the video on YouTube: You can regi …
Speaking @ PASS Summit 2017
After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far. I’ve started …
Testing DML Statements for In-Memory OLTP
Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
The Case of the Space at the End
A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting? How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root …
Free Webcast – 3 Common Mistakes to Kill SQL Server Performance – My Best Online Presentation
Lots of people ask me what is the one thing which I am very much proud of in my life. The answer is very simple, I am very much proud of the webcast, which I have done for Group By Conference 3 Common Mistakes to Kill SQL Server Performance. You can wa …
How to Count Week Days Between Two Dates? – Interview Question of the Week #132
Question: How to Count Week Days Between Two Dates? Answer: Some questions are so simple and interesting that it is fun to build a SQL Script for them. When I searched for an answer to this question, I found quite a few answers online. Actually, a …