How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
294 reads
Adventures in SQL
How Do I Kill All Sessions from a Windows Group?
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
489 reads
T-SQL Tuesday #005 – Self Service Performance Information
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
426 reads
How Can I Tell if a Windows Login has Rights to My Server?
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
315 reads
Script to Create A TempDB File Per Processor
Introduction
Trying to keep the streak alive so here is my 5th blog post in 5 days. This one is another...
2010-04-09
2,000 reads
What Do I Need to Do After Moving a Database to SQL 2005/2008?
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
383 reads
How Do I Identify Invalid or Unneeded Logins?
Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...
2010-04-07
503 reads
Is Anybody Using That Stored Procedure?
Introduction
From time to time I get asked to check if a stored procedure is still used in preparation for dropping...
2010-04-06
477 reads
Get Users By Connection
Introduction
I was recently working a production issue that required me to log in via the Dedicated Administrator Connection (DAC). When...
2010-04-05
335 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,060 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...