Happy Labor Day 2009
It's a holiday in the US and Steve Jones takes a day off with a blooper reel for the editorial.
2009-09-07
630 reads
Articles
Migrating down in SQL Server
In this edition of the SQL Server Mailbag, database expert Denny Cherry tackles reader questions dealing with concerns over downgrading from SQL Server Enterprise to Standard edition, installing SSIS on a second server and more.
2009-09-07
3,011 reads
SQL Server Security Audit (Part 3) - Operating System Level Audit
The final part of the Security Audit series examines how to secure the Windows Server operating system.
2009-09-07
2,582 reads
Getting started with SQL Server Management Objects (SMO)
In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.
2009-09-04
3,737 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-04
3,808 reads
Implementing a SQL Server Fast Track Data Warehouse
This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.
2009-09-04
4,268 reads
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
727 reads
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
714 reads
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
2009-09-04
751 reads
An interview with Josef Richberg - The Exceptional DBA of 2009
Josef Richberg, a DBA with HarperCollins Publishers, has been selected by judges and the DBA community as winner of 2009’s Exceptional DBA Awards, sponsored by Red Gate Software. Freelance writer Bob Cramblitt spoke to Richberg about the role of the DBA and the importance of sharing knowledge with the community.
2009-09-03
2,018 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers