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.
SQL Server Security Part 2
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
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.
Blogs
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers