Overselling Yourself
Posting online is a way of building your own brand, but you need to be careful of overselling yourself. Steve Jones talks about being careful in the impressions you create from your online presence.
Overselling Yourself
Posting online is a way of building your own brand, but you need to be careful of overselling yourself. Steve Jones talks about being careful in the impressions you create from your online presence.
Overselling Yourself
Posting online is a way of building your own brand, but you need to be careful of overselling yourself. Steve Jones talks about being careful in the impressions you create from your online presence.
The Ghost in the Machine
Now that hierarchical data structures are popular again because of XML, their full hierarchical processing is still being limited to flat two dimensional linear path processing by relational processing. This will change when database professionals realize that ANSI SQL relational processing can now support full multipath nonlinear hierarchical processing.
Validate SQL Server Backups Exist with Policy Based Management
I recently submitted a tip regarding the existence of your backup files using the undocumented system stored procedure xp_fileexist. But how would you go about executing that script against all your SQL Server 2005 and SQL Server 2008 instances? I took that script and decided to go one step further using Policy Based Management to create a custom policy that you can then run against all your SQL Server 2005 and SQL Server 2008 instances.
Encryptionphobia
The battle to secure personal and business data is a tough one, and the consequences of mishandling sensitive data can be severe. In this guest editorial, John Magnabosco argues that it's high time people overcame their fear of encryption.
Theoretical Performance Issue Handling
Theoretical performance issue handling or handling theoretical performance issues from new author R. C. van Dijk.
Two Factor Authentication
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
Attaching a database in Microsoft SQL Server 2008
Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.
Reporting Services System and Item Security
Recent installments of our series have focused on SQL Server 2005 Express Edition's implementation of the Reporting Services component. This article addresses our temporary disregard of security restrictions by describing authentication and authorization functionality that can be leveraged to control access to published content and management characteristics.
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