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
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers