Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated
Come get a free day of SQL Server training in Birmingham on Jul 30, 2011.
Get three days of training in Raleigh, NC on Aug 18-20. There are free and paid options that you can read more about.
In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
See a short and dirty example how to use temporary table in user defined function (UDF).
A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser
SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.
On Thursday July 20th, MCM Gaurav Aggarwal will provide an overview of the different options on MS platform for Hadoop
Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?