Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
851 reads
Blog Posts
Tip on Speaking (and Writing) Well – The Key Idea
Cross-posted from the Goal Keeping DBA blog:
In the September 2010 issue of Toastmaster magazine there’s a great article by Chris...
2011-03-28
1,276 reads
Torn page detection vs Page Checksum
TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The...
2011-03-28
907 reads
5 Days to Outstanding DBA Customer Service
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
660 reads
Cluster failover – what’s the best way to get notified?
G’day,
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check...
2011-03-27
2,832 reads
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,372 reads
SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,013 reads
Index Black Ops Series
Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats. The series investigates how the...
2011-03-26
845 reads
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
490 reads
DevWeek 2011 – Day 1
Unfortunately, I couldn’t be in two places at one time, there were two tracks dedicated to the SQL Server DBA...
2011-03-25
717 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers