The internet provides everyone the ability to access data at any time, for any need. Unfortunately, it does not help guarantee that the data is valid, or clean. In the past year I have earned certifications in three areas: Data Science, Big Data, and Artificial Intelligence. Those studies have provided me the opportunity to explore … Read more
Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.
Your database design is awful. The reason nobody has told you this yet is for one of two reasons: ignorance or apathy. They either don’t know it’s bad, or they don’t care. Well *I* care about bad designs, as I typically bear the burden of having to make queries run fast and overcome the limits … Read more
A short time ago a colleague asked me where he could find a “Databases 101” guide for the non-technical professional. He wanted something to help make sense of data and databases, specifically relational versus NoSQL.
I noticed some MSDN forum posts regarding SQL Audit not showing the full SQL statement. To the end user, it appears that SQL Audit is truncating of SQL statements. I decided to write a quick post to help clear up the confusion for large SQL statements and how they appear in SQL Audit.
After months of work, I am excited to announce the launch of SQL Server Buzzfeed!
