Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.
2019-12-09
18,206 reads
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
2019-10-15
12,836 reads
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
2019-10-07
9,361 reads
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Comments posted to this topic are about the item Personal Contact Is Vital
Comments posted to this topic are about the item Getting the Schema for Tables
Comments posted to this topic are about the item An Unexciting Exciting Release
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers