I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.
Tag: DBA
I’m speaking at SQL Saturday 749 : Baton Rouge
Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many other exciting speakers from around the country. My topic is a performance troubleshooting guide for DBAs; but, all are welcome to attend. This year is going to be amazing so be sure to register and block your calendar. Check out the registration here:
You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in everything. I see a lot of people gravitate towards performance; but, that’s not the best place to focus. If you don’t know the fundamentals of the language then you will never be the best performance tuner.Read More »
Monday morning comic 2018-05-21
I decided to poke fun at ORM tools again this week. Hope you enjoy.
Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more than just a database; but, products that ingest data for analysis still need to get the data from a source, such as an OLTP SQL database.Read More »
SQL Tuning: Finding statements for missing indexes
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.
The missing index DMVs are great but they’ve always been missing something.
Query tuning: Apply yourself
It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.
SSMS now has a vulnerability report
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look how many people are listening to the perf tuning session vs the 3 people attending the security session.
The best overlooked addition to SQL 2016
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the hip new thing as opposed to quality of life. I’ve even recently heard people complain to Microsoft that they only focus on new features instead of making existing ones better.
Classifying your data in Azure SQL DB for GDPR
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio (SSMS); though, the management tasks available from SSMS for Azure SQL DB may not exist, such as: data classification.
