T-SQL Best Practices
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Foreign Keys, Part 2 - SQL School Video
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When you factor in the complexities of Active Directory and SQL Server’s interaction with it fixing SSPI errors can be down right baffling...
Checksum Problems, Choosing the Correct Recovery Model and More
Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
Creating a table with horizontal partitioning in SQL Server
During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
I Want a Database
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers