(Mis)Using DBCC Page
In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t...
2012-10-15
1,483 reads
Blog Posts
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,856 reads
How to secure SQL Server?
Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...
2012-10-15
849 reads
IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM
Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...
2012-10-15
586 reads
Introduction to SQL Server at Christmas
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-15
727 reads
Last Weeks Top 10 “Reading” Links #2
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-15
718 reads
Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there...
2012-10-15
973 reads
Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...
2012-10-15
10 reads
Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
410 reads
Microsoft Security Bulletin MS12-070 for SSRS
Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...
2012-10-15 (first published: 2012-10-09)
4,296 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
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