Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...
2014-10-27 (first published: 2014-10-20)
6,815 reads
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...
2014-10-27
16 reads
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
287 reads
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,595 reads
Reading Time: 2 minutes
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce...
2014-10-24
514 reads
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
784 reads
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-10-24
789 reads
Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Important Disclaimer – I have started writing this blog post over 1 months...
2014-10-23
346 reads
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between 2 tables that is...
2014-10-23 (first published: 2014-10-17)
7,703 reads
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is the link so you can read that article first...
2014-10-22
7 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers