SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,231 reads
SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,166 reads
SQL Server – Using Tools to Analyze Query Performance
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
954 reads
SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
758 reads
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,127 reads
SQL Server – Restoring a TDE Encrypted Database to a Different Server
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
977 reads
SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
750 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,473 reads
SQL Server – How to Add More Than One Column as a Primary Key
Sometimes you might want to add more than one column as primary key. For example, if you have three columns...
2013-09-17
592 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
485 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)...