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
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I