Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails
Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
The Data Loading Performance Guide
This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.
8 Clicks to What Changed
Finding out what happened on a SQL Server instance can be a challenge for even experienced DBAs. SQLClue, a new tool by longtime SQL Server expert Bill Wunder can help. We have a short case study that shows you how this tool can help.
Instrumenting Code - Database Weekly (Feb 23, 2009)
In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...
Retrieving Deadlock Graphs with SQL Server 2008 Extended Events
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
SQL Saturday Comes to Pensacola
SQL Saturday comes to Pensacola, June 6, 2009. Read on to get more information and sign up for a one day, free training event.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Can you shrink your transaction log files to death?
can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers