User-defined Data Type Basics
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,198 reads
Administration
Building a Demo Server - Part 2
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
2002-12-13
3,960 reads
Setting a Default Database for your Logins
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
2002-12-11
9,980 reads
Implementing Encrypting File System (EFS) with SQL Server
EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
2007-09-22 (first published: 2002-12-09)
32,417 reads
Utilizing fn_virtualfilestats
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,106 reads
2002-11-27
7,430 reads
2002-11-22
14,562 reads
How to Diagnose and Fix Wait Locks
This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.
2002-11-21
36,221 reads
Review of Real-World SQL-DMO
Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!
2002-11-19
5,266 reads
Removing Orphan Users from All Databases on Server
In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server.
2002-11-18
16,114 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Are topic notifications working?
This is a topic to test whether reply notifications are working or not.
Connecting ERP system E2 and Extract Data , perform Transformation
Hello, May someone please help me how can I pull data from ERP named...
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers