Drag & Drop Table & Column Names in SSMS
I was working with a developer the other day and he was typing out each table name and all the...
2016-11-09
1,039 reads
I was working with a developer the other day and he was typing out each table name and all the...
2016-11-09
1,039 reads
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,084 reads
A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are...
2016-09-22
722 reads
In SQL Server 2014 SP2 an interesting new DBCC command was included, DBCC CLONEDATABASE
This command creates a “clone” of a...
2016-08-22 (first published: 2016-08-17)
2,787 reads
One of the server settings that I always enable when configuring a new instance of SQL is database instant file...
2016-08-03
454 reads
SQL Server 2016 CU1 has been released and one thing I noticed was: –
FIX: Canceling a backup task crashes SQL...
2016-07-27
835 reads
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...
2016-07-20
1,354 reads
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...
2016-05-02 (first published: 2016-04-22)
1,848 reads
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,125 reads
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...
2016-04-06
517 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en California El Departamento...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers