Ruthless
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
Using OpenDataSource - SQL School Video
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
Collecting performance counters and using SQL Server to analyze the data
Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
Measuring the Impact of Task Switching/Multitasking
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non uncommon cases also keeping up with Facebook, Twitter, and more. Often it's multiple tasks, and we get better at plate spinning.
Testing a SQL Server environment before an upgrade
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
SQL Unit Testing
This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
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