SQL SERVER Interview Questions
All you who wants to pursue professional life as SQL SERVER DBA, its always hard to crack the interview . But...
2015-05-08
1,509 reads
Bringing Together Databases, Virtualization and Storage
A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks...
2015-05-08
384 reads
002 – SQL Server 2016 - WaterOx Consulting
Reading Time: 1 minutesIt is official! The next version of SQL Server will be SQL...
The post 002 – SQL Server 2016...
2015-05-08
670 reads
PSA: Update Your PASS Profile
I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m...
2015-05-07
907 reads
Video: Bringing Together Databases, Virtualization and Storage
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server,...
2015-05-07
372 reads
Reframing to Overcome Filtered Index Limitations
I’m continuing on with the Blogger’s challenge in this post.
Turning the Problem Around
In the last post, I wrote about limitations...
2015-05-22 (first published: 2015-05-07)
4,287 reads
PASS Elections and Verifying Account
It is that time of the year when PASS starts a process to help update memberships and clean up duplicate...
2015-05-07
446 reads
Free Your Mind. Release Your Inner Developer
I have always liked the drawings done by MC Escher. Looking at his drawings has always forced me to look...
2015-05-07
423 reads
Putting Your Head in the Clouds 2 –Advantages and Disadvantages of Cloud Solutions
By David Postlethwaite
If you are thinking about using Cloud Computing then it’s worth considering the pros and cons.
Advantages of...
2015-05-07
564 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...
2015-05-06
14 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