Advanced Analytics with R and SQL Part II – Data Science Scenarios
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster
Today the progress made in technology is astounding and beyond our imaginations, but still there are clients who can’t move to higher, latest and greatest version of SQL so easily. They are still stuck with SQL 2005 and SQL 2008 SQL servers. In t …
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 …