The Growth of Professional Development
Steve Jones talks about the more formal effort that it seems many people are placing to grow their careers.
SQL Rally: One Day on Query Performance Tuning
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
SQL Server Email Alerts Notifications
This article details a creating a more flexible and user friendly email alerts system.
Vote for my precon workshop for PASS SQLRally
I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...
Vote For The SQLRally Pre-Con Seminars
Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...
You know you want it! - SQLRally Precon Voting
For those of you who have seen our team present, we always do our best to make it really informative,...
The Hybrid
Steve Jones talks about SQL Server Connections, the conference that might be the place to be for hybrid IT workers.
Writing Nearly Codeless Apps: Part 4
Part four of this series on rapid application development looks at the CRUD routines that are needed for almost every application.
Replication Schema Option Across Different Versions of SQL Server
My company uses replication quite extensively across SQL 2000, SQL 2005 and SQL 2008 servers. The problem with using different versions of SQL Server is that the replication options do not always behave the same way. Because of these differences we have stopped using SQL Server Management Studio and Enterprise Manager to setup replication. Also we have taken the time to look at the schema options for replication to make sure the end result is the same for all versions of SQL Server.
State Transition Constraints
Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer. A commercial world is full of complex rules for sequences of procedures, of fixed or variable lifespans, Warranties, commercial offers and bids. All this requires considerable subtlety to prevent bad data getting in, and if it does, locating and fixing the problem. Joe Celko shows how useful a State transition graph can be, and how essential it can become with the time aspect added.
Blogs
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...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
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