Why store sensitive data if you don't have to?
Storing sensitive data in your database leads to security risks. Learn how not storing sensitive data indefinitely is a form of data protection.
A Smart Smartphone
Cell phones are great communication tools, but that's mostly what they do, even for IT folks. But Steve Jones talks about some other possibilities and potential problems.
Data Modeling using ERWIN and SQL Server 2000
Using data modeling tools should be something that all SQL Server DBAs involved in development use, but most of us cannot afford the tools or have the expertise to use them. Jambu Krishnamurthy brings us a new article that shows how you can use Erwin to work with your data model.
Moving the tempdb database
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
SQL Server Reference Guide
Buck Woody's SQL Server Reference Guide is your "one-stop shop" into the world of Microsoft's SQL Server, providing you with the information you need to manage and program SQL Server.
Breaking Things Apart
Microsoft is unbundling their new hypervisor from Windows. Could this happen with SQL Server?
Introduction to Bitmasking in SQL Server 2005
The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
File Management with Scripting Object
Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).
Blogs
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers