Insights and news from the SQL Solutions Group.
SQL Server and the (not so mysterious) Mystery of Three-Valued Logic
SQL Server’s three-valued logic is a concept that extends the traditional two-valued logic to include a third value, known as NULL. Three-valued logic is used to handle cases where the value of a column in a database table is unknown or not applicable. Get to grips with this complex idea.
How To: Running SQL Jobs with Azure Functions
In my previous blog post I introduced Azure Automation and Runbooks and showed how to automate index maintenance using these Azure technologies. This blog post is
How To: Azure Automation and Runbooks
In my previous “prologue” blog post I introduced a small handful of topics that discuss how to automate things in Azure, specifically SQL agent jobs.
Why you should never … use SQL Server default memory settings
We frequently see SQL Server instances that use the default memory settings, or settings that do not optimize performance. The default settings are 0 MB
Run SQL Jobs in Azure: A Prologue
This is an introduction to an upcoming series of posts dedicated to supporting you and addressing the different ways to not only do index maintenance,
A SQL DBA New Year’s Resolutions- Habits we won’t be bringing with us into 2023
The New Year is upon us, can you believe it? I love this time of year. Thinking about my goals, setting up my 2023 calendar,