Reporting Services Licensing
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple...
2009-12-17
2,816 reads
How to Shrink TempDB in SQL 2005
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,057 reads
How to Copy Query Results From SQL Server 2005/2008 into Excel
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio...
2009-12-17
5,067 reads
Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
408 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,266 reads
Securing Log Shipping
There was a post recently where someone was asking about securing log shipping to comply with HIPAA requirements. It struck...
2009-12-17
1,228 reads
Using Google Docs for Note Taking
I've admittedly been a terrible note taker growing up. Throughout most of school, I've always been able to remember everything...
2009-12-17
2,127 reads
Machine SID Doesn’t Matter
Ran across this post from Mark Russinovich titled The Machine SID Duplication Myth that seems to debunk the idea that...
2009-12-16
783 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,470 reads
Updated SQL Server 2008 Diagnostic Queries
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
984 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers