Upgrade from SQL 2014 Evaluation to Developer Edition
Couldn’t find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted...
2015-05-04
562 reads
Monday Morning SQL Break – May 4, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on...
2015-05-04
737 reads
SQL Code Guard v2.8 released
Main change - SCG moved back to .Net framework 3.0 to restore support of SSMS 2008/2008R2
Few small fixes, additional logging, nothing...
2015-05-04
581 reads
Building a job to monitor other jobs
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...
2015-05-14 (first published: 2015-05-04)
6,498 reads
I am not able to access my SQL server instance on another computer tip #98
On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server...
2015-05-11 (first published: 2015-05-04)
5,931 reads
ETL #72–Your data can mysteriously disappear after a WHERE clause was added (2)
Why a seemingly innocent WHERE clause can cause large amount of data missing
In the previous post, ETL #71–Your data can...
2015-05-12 (first published: 2015-05-03)
6,273 reads
Overview of Azure Data Services
The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all...
2015-05-03
676 reads
Using SQL Code Guard TFS Checkin Policy with VS2013
To use TFS Checking policy the first thing that you must do - is to add policy to your TFS source...
2015-05-11 (first published: 2015-05-02)
6,047 reads
Microsoft SQL Server RELEASES
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database its primary function is to...
2015-05-02
818 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
19 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers