Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
SQL Server Magazine has issued a last call for submissions to its 2003 Innovator Awards program. Your SQL Server technical savvy could win you a trip to Palm Springs--if you hurry. The deadline for submissions is August 1. The awards program...
In tough economic times, IT infrastructure investments are the first to go. From the typical C-title perspective, infrastructure is a necessary evil: You need it to do business, but it doesn't directly contribute to sales, customer satisfaction...
Why does the command SELECT LEN('123' + ' '), which counts the number of characters in a field, return three when it should return eight? Three characters plus five blank spaces is eight characters in total. How can I count the blank spaces...
In the May Q&A "Checking Port Numbers" (InstantDoc ID 38444), I responded to the following reader question: "I created a server alias that uses the TCP/IP network library. The client-side server alias is configured to Dynamically determine...
If you're dying to dabble with business intelligence (BI), but don't know where to start, you might want to investigate SQL Server Accelerator for Business Intelligence. On June 25, 2003, Microsoft announced the product's latest release, which...
Microsoft adopted a standardized naming schema for all SQL Server hotfix patches or updates that the company creates or distributes. The new schema uses the format "ProductName-KBArticleNumber-BuildNumber-Language.exe." For example, a SQL Server...