|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources that no further connections can be made. Although extreme and a situation I have never been in there is a saving grace, one last chance before opting for measures that…Read more
I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience they do a pretty mediocre job at best and at times can be absolutely horrific. The issue was that the statements being fired at an instance of SQL Server from…Read more
For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools menu in Management Studio. This tool was first introduced in SQL Server 2005 and has been a much used tool by DBA’s and Developers alike in most of the companies…Read more
Over the weekend I finished reading yet another Red Gate book, this one was SQL Server Hardware by Glenn Berry (t - b). Having earned my crust as a Windows Engineer before honing my SQL Server Skills and becoming a DBA, I have had this book on my…Read more
This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using SQL Sentry Performance Advisor I highlighted four or five procedures to start with. I was able to get a couple of quick wins which was a result, then…Read more
Parallelism, where to start? Well let’s start right at the beginning shall we with the question, what is parallelism? Simply put it is a feature of SQL Server which allows queries to utilize more threads in order to complete quicker. There are several ways to influence SQL Servers decision whether… Read more
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it is a long weekend where we camp close to the airfield and get to take in three full days (if you include Friday practice of utterly breath-taking aerobatic displays from…Read more
I came across an interesting issue a few days ago that I thought I would blog about. The issue is replacing NUL characters from values in SQL Server, more specifically using REPLACE(). Take the below TSQL which runs but will never complete;
DECLARE @var VARCHAR(MAX Read more
I promised you some PowerShell scripts this year and this post is the first one. I can see the value PowerShell can bring, but find it equally frustrating. I don’t know the syntax very well or all the command lets and personally for 99.9% of my daily tasks I can…Read more
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it is a brilliant feature. Replication I feel gets a bad reputation for causing a number of problems for DBA’s, in most cases it is something they inherit when…Read more
So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has been. I can honestly say that I have taken a great deal away from this experience which has been so rewarding, the only disappointment I have is that I didn't start blogging earlier. I… Read more
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did however let me down recently. Well when I say LDAP let me down it was probably my knowledge of LDAP (or lack thereof) that let me down.
For an audit… Read more
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script slightly to get all tables without a primary key. A Primary Key constraint enforces uniqueness of a record in a table. I am extremely anal with this particular standard…Read more
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the routine. Investigation led me to find that a new table had slipped through the net and been created without a clustered index. Needless to say adding a clustered… Read more
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can cause unnecessary reads placing additional overhead on, among other things the IO subsystem. Having said that indexes that are in place but never used cause unnecessary writes during… Read more
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t signed up to the insider email I suggest you do as there is wealth of great information provided by the SQL Skills team on a Bi-Weekly basis.
In summary what… Read more
I have been setting up multi instance database mirroring for the last couple of days along with some other DR related processes. I will do a detailed post about these at a later date. I came across this particular error again (for about the sixth or seventh time) Error Message… Read more
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much easier to complete and ensures consistency across the estate. One thing that really irritates me is existing “legacy” environments that do not conform to these standards. For example…Read more
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication in my current position and recently had to setup merge replication between 3 servers on our WAN. For those of you who have used replication in anger Replication… Read more
You have got to love the way the SQL Server team change the lingo in all of their high availability (HA) / disaster recovery (DR) features. To a novice and even to more seasoned DBA’s it can be confusing, this post will not go into the nitty gritty of how… Read more
Older posts
|
Subscribe to this blog
