Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
2008-11-05
83 reads
Articles
Faking Multidimensional Arrays in T-SQL made easy!
Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!
2008-11-04
11,814 reads
Using Break Points in SSIS - SQL School Video
MVP Brian Knight brings us a look at how you can easily debug your Integration Services packages.
2008-11-04
4,837 reads
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
2008-11-04
173 reads
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
2008-11-04
162 reads
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
2008-11-04
159 reads
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what can you do with GIS Data? We asked an expert!
2008-11-04
4,121 reads
Using Powershell to Generate Table-Creation Scripts
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
2008-11-04
2,834 reads
How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
9,388 reads
Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment
Implementing a dialog between two services residing in a distributed environment requires the presence of an authentication mechanism. Windows-based Kerberos protocol limits the scope of systems participating in a Service Broker dialog to those residing in the same or trusted Active Directory domains. This article provides an overview of how to eliminate this limitation by employing certificates.
2008-11-03
2,198 reads
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