SQL Server 2008 R2 Service Pack 2
Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through...
2012-07-28
2,358 reads
Blog Posts
transparent data encryption steps
In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012...
2012-07-28
1,580 reads
As one door closes another one opens
Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...
2012-07-27 (first published: 2012-07-23)
2,531 reads
Color Expressions in SSAS Calculations
Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...
2012-07-27
1,693 reads
Different techniques to identify blocking in SQL Server
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2012-07-27
1,594 reads
How To Prevent SELECT * The Evil Way
SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...
2012-07-27
1,897 reads
Licensing SQL Server Dev/Test Environments
I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and...
2012-07-27
20,293 reads
Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario
Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server
2008 R2. You can download the Service Pack...
2012-07-27
2,582 reads
SQL Saturday #150 Baton Rouge 2012
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
784 reads
SQL Server 2008 R2 – Service Pack 2 now available
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Stay...
2012-07-27
1,408 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