Locking and Blocking from Joe Webb – DevConnections
Locking should be simple, right? You need to access a row or table and you get a lock. Oh yeah,...
2011-03-29
689 reads
Locking should be simple, right? You need to access a row or table and you get a lock. Oh yeah,...
2011-03-29
689 reads
Brian Kelley, speaking on the SQLServerCentral track.
A bit of a crazy day for me, starting off a crazy week. I...
2011-03-28
743 reads
Red Gate Software is announcing SQL in the City today, a series of events that will bring a free day...
2011-03-28
1,453 reads
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,024 reads
I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...
2011-03-21
782 reads
There’s been some work to close out items in Connect that aren’t going to be fixed. I don’t know exactly...
2011-03-17
877 reads
Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I...
2011-03-15
836 reads
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,009 reads
I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken...
2011-03-10
1,719 reads
I had the main room keynote at the recent Rocky Mountain Tech Trifecta v3.0 in Denver. Jeff Certain & Ben Hoelting...
2011-03-09
1,005 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
My knowledge of Extended Events is limited, but I am trying to capture some...
I've got something I'm not aware of performing backups of my dbs at random...
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers