Scripts from a regular SQL Server database used to fail on SQL Azure. With SQL Server 2008 R2 you can generate a database script for SQL Azure. Here is how.
SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days
A non-technical post on how I balance SQL Server training and consultancy, plus the story of my last 30 days of sessions and travel.
SQL SERVER – Stored Procedure and Transactions
Is a stored procedure transactional by itself? No. A simple example with three tables shows why stored procedure and transactions are separate things.
SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision
The precision of SMALLDATETIME is 1 minute. Seconds are rounded up or down to the nearest minute, and this simple example shows exactly how.
geometry STUnion: Merge the Shared Area Only Once
geometry STUnion merges geometry coverage. These exact-coordinate rectangles distinguish a combined area from the sum of two areas, including duplicate coverage.
REGEXP_INSTR: Locate a Match or a Capture Group
REGEXP_INSTR returns the position of a selected regular-expression match or capture group. I compare its positional arguments using one short string. This example needs SQL Server 2025 and database compatibility level 170.
SQL SERVER – Disabled Index and Update Statistics
A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.
SQL SERVER – DATE and TIME in SQL Server 2008
What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.
SQLAuthority News – SQL Server Technology Evangelists and Evangelism
Am I an evangelist, a mentor or a founder? A funny talk from my public training about SQL Server Technology Evangelists and what my title really is.










