Sometimes coincidences happen that make you sit back and say Hmm. Couple of days back Ovidiu, one of our senior developers, came by and asked me to blog about the Pivot transform. Then earlier today someone doing a high end POC down south need the same information.
2005-11-09
2,070 reads
SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.
2005-11-08
16,148 reads
Where does Access fit in Microsoft’s future? Before that question is answered, we should examine why it might be important.
2005-11-08
5,350 reads
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
2005-11-07
3,833 reads
Backups and restores are two fundamental tasks that a DBA must perform correctly. But remembering the syntax, options, decoding filenames, etc. can often be busy work that leaves a DBA open to mistakes. New author Vince Iacoboni brings us his code and techniques for a set of stored procedures to make handling backups and restores very simple.
2005-11-07
13,499 reads
If you are deploying Reporting Services on SQL Server 2005, you may run into an issue when installing an SSL certificate. David Russell brings us some information on what could happen and how to successfully install.
2005-11-07
13,721 reads
Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates the conversion of Sybase ASE (Adaptive Server Enterprise) T-SQL stored procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.
2005-11-04
1,103 reads
How do you find the next business day? What is a next business day? Holidays, country specific issues, etc. all come into play with many business functions and it can be a complicated process. New author Rob Scholl brings us a recursive function in TSQL to help solve this problem.
2005-11-03
13,599 reads
The November issue of the SQL Server Standard is out and being mailed to everyone. Read the editorial and get the table of contents.
2005-11-03
3,301 reads
2005-11-03
3,365 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers