Where does Access fit in Microsoft’s future?
Where does Access fit in Microsoft’s future? Before that question is answered, we should examine why it might be important.
Cryptography In The Database
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
More Intelligent Backup and Restore
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.
SSL Certificates on SQL Server 2005 for Reporting Services
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.
Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1
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.
Finding the Next Business Day Recursively
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.
November SQL Server Standard - Business Intelligence
The November issue of the SQL Server Standard is out and being mailed to everyone. Read the editorial and get the table of contents.
SQL Server 2005 Adoption Rates
How many people are getting ready to upgrade to SQL Server 2005? Why are they upgrading? Why not? Edgewood Solutions conducted a survey and the results are in. Read on for the executive overview and learn how to get a complete copy of the results.
SSIS - Reusable Benchmark Harness
We all know testing is important, but face it, testing is not the highlight of anyone's daily work. And more important than testing your code the first time is regression testing after you have fixed a few bugs. Kristian Wedberg brings us a new article that uses SSIS to build a harness that allows repeatable testing of code and applying benchmarks to be sure that things are working as expected.
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers