Joseph Sack

Joseph Sack is a SQL Server consultant based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, and manufacturing. He is a Microsoft Certified Database Administrator (MCDBA). Joseph has written for SQL Server Magazine, and recently wrote a book called “SQL Server 2000 Fast Answers for DBAs and Developers”. For questions or comments, feel to contact him at www.joesack.com.

SQLServerCentral Article

Stored Procedure Naming Conventions

As your SQL Server applications grow, chances are that you have more and more objects, especially stored procedures that you need to keep track of. An organized environment is key to being able to prevent the duplication of code and effort. Joe Sack brings us a look at how he names stored procedures to easy identification.

3.86 (7)

You rated this post out of 5. Change rating

2005-10-03

25,052 reads

SQLServerCentral Article

Using DTS to Generate and Email Excel Reports

Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.

5 (7)

You rated this post out of 5. Change rating

2005-09-23 (first published: )

40,237 reads

SQLServerCentral Article

Analyzing Data Storage - Ten SHOWCONTIG Queries

Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some time to develop given that the tools are rather limited. DBCC SHOWCONTIG is one of the few ways in which you can get some insight into how SQL Server has structured your table on the disk. Joe Sack brings us another of his top xxx techniques with his ten queries that you can use to analyze the results of this command.

4.64 (11)

You rated this post out of 5. Change rating

2004-08-16

22,987 reads

SQLServerCentral Article

Seven Showplan Red Flags

SQL Server showplan is a great tool for analyzing queries and determining whether or not more performance tuning needs to be done. However working with showplan can be confusing and it takes some practice to learn the ins and outs of what is occurring. Joseph Sack looks at showplan and seven of the main things that he is aware of when looking at the results. If you've rarely or never used showplan, this is a great article to get started in learning how an experienced DBA views the output.

5 (4)

You rated this post out of 5. Change rating

2004-07-15

21,926 reads

Blogs

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs

Forums

txt file Pipe

By juliava

Hello, I need to put data from table to txt file as pipe on...

Case statement to insert a new line in query output??

By jbalbo

Hi I need to insert a new line of my output when a condition...

Database Mail to work on Azure VM

By terry999

Trying to get Database mail working sending via  outlook.office365.com or smtp.office365.com port 587 using ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers