Mapping Database File Objects and Fragmentation
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
2003-10-16
8,779 reads
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
2003-10-16
8,779 reads
Chris has been working through the process of upgrading to Win2003 and has the start of a great checklist along with few lessons learned - stuff that will come in handy it's time for you to do your own upgrade.
2003-09-11
10,894 reads
Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
422 reads
In part two of this article Chris explains how to handle some common issues you'll run into while using version control and how to manage the process. Defintely read part one first if you haven't already.
2003-07-16
4,768 reads
We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.
2003-07-07
5,566 reads
Chris does a lot of work with IIS and based on that he put together this nice map showing how all the bits and pieces go together. No SQL here, but most of us deal with IIS so we thought it might be of interest.
2003-07-02
5,813 reads
This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.
2003-03-18
12,176 reads
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
2002-12-04
8,073 reads
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
2002-02-18
9,850 reads
Displays the hit ratio of the buffer, procedure and log caches. Does not check for div by zero as I am lazy. Tested on SS2k (any SP).
2002-01-15
895 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi everyone I need to find the last business of the week. In most...
Please share a situation when enabling and taking further advantage of DBCC TRACEON -...
All, Need a linked server guru. Trying the following in a stored procedure: SET...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers