Initialize a Transactional Replication from a Database Backup
During the last days I'm working on Replication – especially with Transactional Replication.
The main idea of Transactional Replication is that you...
2012-08-05
9,177 reads
Blog Posts
SQL Server : List Login's Database and Server Level Role Permission
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,536 reads
SQL Server 2008 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-08-05
1,099 reads
Chennai SQL Server User Group (CSSUG) meet
Let me start with my sincere apologies first for not blogging consistently.
Primary reason is, my wife gave birth to our...
2012-08-04
1,350 reads
Getting to the next level in your SQL Server career
Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen...
2012-08-04
1,288 reads
Protect Against SQL Injection Using Triggers
Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes...
2012-08-04
629 reads
SQL Server Quickie #2 - Extents
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm
talking about Extents, and how SQL...
2012-08-04
1,132 reads
SQL Server Quickie #2 – Extents
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...
2012-08-04
644 reads
Exporting Data Using BCP
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
10,683 reads
Identity Insert and Table Variables – CONNECT issue
I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))
INSERT...
2012-08-03
2,755 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