How to Monitor for High CPU utilization in SQL Server
This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.
Unprofessional Employers
This Friday Steve Jones talks about training and employers, and who has the responsibility for your knowledge? Let us know if you think your employer shares the burden with you.
Exporting Master Data from Master Data Services
This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.
The Technical Nuances of Technical Writing
A helpful guide to writing technical papers by focusing on the non-technical elements.
Windows Server 2012 and Hyper-V
Steve Jones talks about the improvements in Hyper-V in Windows Server 2012. These days there isn't a good reason to avoid considering virtualization for SQL Servers.
Exploring Semantic Search Key Term Relevance
SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come up with a system to rival the industry-leaders, one that could extract the contextual meaning of terms in text, or automatically categorise the subject matter of text? On first inspection, it seems unlikely.
Manage By Delegation
There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.
Stairway to XML: Level 6 - Inserting Data into an XML Instance
The modify method lets you manipulate XML data using XML DML. It can insert, alter or delete data. In this level, Robert shows how to use the method to insert a node into an XML instance.
Report Builder 3.0: Adding Charts to Your Report
Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts and reports that will be intuitive to anyone who has done the same in Excel. Robert Sheldon provides a simple explanation of how to get the best from charts using Report Builder.
I'm Not a Rock Star
Steve Jones reflects on the SQL in the City tour that recently wrapped up in the US.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers