Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,337 reads
Blog Posts
I’ve Moved and So Should You
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
522 reads
Improve Performance and Take a peak, at SafePeak for SQL Server
There's an exciting new product on the market, and Pearl Knows is in on the ground floor, and wanted to share.
If...
2010-03-21
673 reads
Info about Maximum specifications for SQL Server 2008/2005
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008...
2010-03-21
1,243 reads
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is
a cookbook style book for experienced SSRS designers...
2010-03-21
541 reads
Script: Transaction Log Backup
My last post showed a little script that I use for taking full backups of all my databases on an...
2010-03-21
7,789 reads
Snagit…
If you read my last post, you may have noticed that my images now include boxes, balloon text and highlighting. ...
2010-03-21
563 reads
A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-20
2,814 reads
Determine which version of SQL Server is running...
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,067 reads
Random Thoughts on Aliasing
Here are many different thoughts/facts/preferences on aliasing. Most of this applies to column aliasing. Regardless of whether or not you...
2010-03-20
1,353 reads
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...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
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