Configure SQL Server Database Mirroring: Step By Step
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...
2016-04-05 (first published: 2016-03-25)
97,632 reads
Hemantgiri
- Interests: Reading,Writing,Painting
- Twitter: @https://twitter.com/hemantgirig
- Website: https://www.sqlservercitation.com
- LinkedIn: https://www.linkedin.com/in/hemantgirisgoswami/
SQL Server Community Activities under Surat User Group
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
346 reads
Blog Roll - List of blog post and script contribution
Greetings of the day!!
I am getting frequent emails with questions why I do not write as often I used to...
2016-01-11
502 reads
SQL Server GEEKS Annual summit 2015
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...
2015-08-02
689 reads
SSAS– Resolving target machine actively refused
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....
2013-11-08
980 reads
SQL Server–Security Risk Assessment PMP Way
Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project...
2013-11-02
1,176 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
988 reads
Not so good news for MCM Aspirants
Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification,...
2013-09-05
746 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,251 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,896 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers