Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
2021-02-26
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.
2021-02-23
Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them.
2021-02-22
Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration.
2021-02-19
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
2021-02-18
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
2021-02-17
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.
2021-02-15
In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more.
2021-02-12
Phil Factor explains how to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of database automation scripts that will build a SQL Server database, and then update it, running a series of migrations scripts that make some schema alterations, and load the database with test data.
2021-02-12
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
Comments posted to this topic are about the item The SQL Server Date Magic:...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers