VMware vCenter 5.1 ADSI quirk
I sat down this afternoon after being out of town for week to work on a few things in my...
2012-09-30
1,546 reads
Blog Posts
Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2012-09-29
1,287 reads
Basics of Triggers in SQL Server
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2012-09-29
1,417 reads
Parallel Execution in SSIS 2008 and later version
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now question is how we can configure SSIS to run...
2012-09-29
290 reads
Parallel Execution in SSIS 2008 and later version
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now...
2012-09-29
986 reads
Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,510 reads
I voted in the PASS Election - you should too!
If you are a member of PASS you have probably already received an email that looks like this:
--
From: <hq@sqlpass.org>
Date: Fri,...
2012-09-28
1,683 reads
Reblog – September 21 to September 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-09-28
1,463 reads
SQL Server: Part 2 : Approaching Database Server Performance Issues
In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on...
2012-09-28 (first published: 2012-09-21)
3,789 reads
Time to Vote-PASS Board of Directors
It’s that time of year where we get to vote for the three best candidates to serve a two year...
2012-09-28
1,515 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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