Quantifying Text differences in TSQL In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner or later, usually when cleaning data, something more subtle is required!

Pop Rivett and the FTP directory Dr Pop Rivett diagnoses URL-Aphasia in an anxious and exhausted patient and divulges a technique of synchronising a local directory with a remote FTP directory, all in TSQL!   Can you Break The Code? Fancy winning some cool goodies? Red Gate has just launched its "Break The Code" competition, and to make it worth your while trying, we're offering prizes worth over $1000   "Brown Shoes Don't Make It" Every book on interviewing will soothe you into believing that what you wear during the ordeal isn't so important as how you conduct yourself. Phil squirms with embarassment at the memory of the...   Automate your Database Integrity checks using SMO Allen White shows how to use Visual Basic to create simple routines that use SMO for inserting and deleting jobs from SQL Server Agent and for creating or deleting stored procedures in SQL Server.   Pivots with Dynamic Columns in SQL Server 2005 András Belokosztolszki discusses the PIVOT operator in SQL Server 2005, and suggests a novel approach to constructing the Dynamic SQL, using XML, that works around the PIVOT operator's innate...   Changing Service Credentials One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.   Close These Loopholes - Testing Database Modifications In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications   SQL Refactor and the Table Splitting Headache SQL Refactor is well-known as a way of formatting, and beautifying, SQL Code from within SSMS, but few users seem to be aware of the Table-Splitting wizard. This wizard is explained by another,...   A Cynic's Top Ten Tips for IT Contractors As autumn approaches, Patrick Index produces his ten hot chestnuts for IT Contractors like himself, with a jaundiced 'contractors-eye view'.   Reporting Services Cribsheet If you tend to just nod gravely and stay silent when SQL Server Reporting Services is mentioned, here is your opportunity to get up to speed with one of the more important technologies associated...

More... Discovering Security Uses for SQL Compare Say hello, static constructor? Comparing Python and PowerShell DBA Scripting Close These Loopholes in Your Database Testing SQL Prompt 3.5 Released RBAR: 'Row By Agonizing Row' .NET 3.5 Language Enhancements Crosstab Pivot-table Workbench Custom reports in Management Studio, using the Performance Dashboard The DBA and the Battle for Reputations

<< Start < Prev 1 2 Next > End >>

Results 1 - 21 of 36