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
Frequent readers of this blog may recall last year I earned a certificate in Data Science through the Microsoft Academy and edX. I followed up with a certificate in Big Data earlier this year. And I now added a third certificate, this one in Artificial Intelligence.
SQL Server 2017 allows for the use of Python scripts called as an external script. SQL Server comes with some Python packages by default. Today I wanted to talk about adding Python packages to SQL Server 2017. To get started with Python in SQL Server 2017 we must enable the use of external scripts. … Read more
For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.
It’s easy to get started analyzing Stack Overflow Data. You can query the database directly or import the data into PowerBI.
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.
