How to Use xp_delete_file to Purge Old Backup Files
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
2,178 reads
How to Use xp_dirtree to List All Files in a Folder
UPDATED -- Dec 31, 2012 -- Be sure to read Part 2 of this post discussing xp_dirtree.
Last week I blogged about how...
2012-11-13
20,572 reads
Dynamically Create a Folder for Each Database
If you're a DBA like me then you're probably pretty detail-oriented and like to keep things very organized. For example,...
2012-11-06
708 reads
Customize the Management Studio Toolbar
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
1,537 reads
Capture Index Usage Statistics for Better Analysis
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,483 reads
Which SQL Instance is Killing Your CPU?
You have 5 instances running. How do you know which one is killing your CPU?
As you can see from Windows...
2012-10-16
537 reads
Grant Execute Permission on All Stored Procedures
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
1,863 reads
How to Make SQL Server Listen on Multiple Ports
Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...
2012-10-05
1,052 reads
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,241 reads
Welcome to Everday SQL
My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years. During that...
2012-09-22
336 reads
Blogs
Daily Coping 22 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...
Suggested Topics in Power Virtual Agents
By Devin-Knight
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...
Forums
Putting a CTE with Subqueries into a stored procedure
Is there a way to place the following code into a SELECT routine in...
Migrating Folder Structure in Report Manager from one SSRS server to another
We are in the process of converting 500+ reports from our old reporting system...
Setting up and using dbt (Data Build Tool) with SQL Server
dbt, or Data Build Tool, is a piece of software that allows analysts to...
Ask SSC