VMware Certification Changes
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...
2014-03-09
731 reads
Auditing VMware vCenter Actions (on SQL Server)
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....
2014-03-07
1,356 reads
Reblog: February 28 to March 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-03-07
854 reads
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
874 reads
DISABLE and DENY LOGIN, DENY USER & Effect on Impersonation and Permissions
DISABLE und DENY LOGIN, DENY USER & Effekt auf Impersonierung und Berechtigungen
(de)
Ein kurzer Artikel zu den Effekten – oder fehlenden Effekten...
2014-03-07
1,004 reads
Friday Followup For March 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-07
464 reads
Different approaches of counting number of rows in a table
Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL...
2014-03-06
1,444 reads
Virtual Lab – Adapter Setup
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-03-06
1,072 reads
The weakest link in database security
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is...
2014-03-06
958 reads
How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a...
2014-03-06
697 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