Free Training Classes for Those Who Give Back: Announcing our 2019 Scholarships
You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization …
Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
Avoid running out of Disk Space ever again using SQL Monitor
If your SQL Server runs out of disk space, and it is running a database for an enterprise’s trading application, then the company can’t take money until the DBA fixes the problem. In this article Tony Davis shows you how to avoid this scena …
Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters
In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.
SQL SERVER – Identifying Query Using TempDB
During the recent Comprehensive Database Performance Health Check we observed that the size of the TempDB is very big for our customer. The first question which they asked was if there is any way they can identify query using TempDB. We ran the fo …
Where is the Default Settings for Backup Compression? – Interview Question of the Week #191
Question: Where is the Default Settings for Backup Compression? Answer: I think before I continue more on this blog post, I must show you an image which has created this question. Please look at the following database settings screen. You can go t …
[Video] Office Hours 2019/09/12 (With Transcriptions)
This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on …
SQL SERVER – Monitor Estimated Completion Times for Backup, Restore and DBCC Commands
Earlier this week, we were fortunate to receive an amazing script to overview HADR / AlwaysOn Local Replicate server from SQL Server Expert Dominic Wirth. You can read the amazing script here: Scripts to Overview HADR / AlwaysOn Local Replica Serv …
Microsoft Docs and Localization Community Platform
Microsoft Docs is the new platform for sharing high quality technical documentation about Microsoft technologies and related products.The documentation is hosted on GitHub and it is open to changes.Now, technical communities around the world have the o …
Should Index Changes Require Change Control?
We got a phenomenal series of questions from a client, and I wanted to encapsulate the answers into a blog post to help more folks out: Should all index changes require testing in a staging environment, no matter how big or small? What would be a reaso …
Microsoft Dynamics CRM – Max Degree of Parallelism Settings and Slow Performance
My primary source of income for me is the Comprehensive Database Performance Health Check for any application using SQL Server. Recently, I was hired by a large organization which was struggling with the poor performance of their Mi …
Quirks When Working With Extended Events To Track Locks
Worse Than Mobile Browsing I have a love/hate relationship with Extended Events. Yes, they’re powerful. Yes, you can track interesting things. But they’re just not intuitive, like, 10 years on. Part of the problem is that the narrative from …
TRY_PARSE
Introducing the PARSE function, brought to us in SQL Server 2012.
It’s official: database development is now part of DevOps
You’ll probably have heard of the Accelerate State of DevOps Report from DORA. Now in its fifth year and backed by rigorous research involving 30,000+ professionals worldwide, it has consistently shown that higher software delivery performance de …
SQL SERVER – Microsoft Azure – Unable to Find Higher Tier Series Virtual Machine to Upgrade
With current market trends of cloud shifting, many of my clients have moved their SQL Servers from on-premise virtual machines to Microsoft Azure Virtual Machines. In this blog, I would explain a situation where my client was not able to find relevant …