Using Xp_cmdshell
One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.
2003-11-14 (first published: 2001-05-03)
39,235 reads
Administration
Moving Logins - A Gotcha!
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,872 reads
Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,388 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,625 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,896 reads
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,790 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,587 reads
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,899 reads
Automatically Gathering Server Information Part 4
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
5,857 reads
Quickly Disconnect Users
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
17,599 reads
Blogs
Updates from Coping Tips
By Steve Jones
I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...
What I’ve learned in my first 100 days with a consulting group
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
Power BI as a enterprise data warehouse solution?
By James Serra
With Power BI continuing to get many great new features, including the latest in...
Forums
How To Flatten JSON Data?
I receive data in JSON files and for one particular type of data I...
Last Cube Refresh Showing Wrong Time
Hi I have a tabular model and have been asked to retrieve the last...
Working with T-SQL function AVG ()
Comments posted to this topic are about the item Working with T-SQL function AVG...
Ask SSC