Think Using .. In Code Is A Time Saver? Think Again!
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
480 reads
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
480 reads
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...
2016-09-22
401 reads
I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What...
2016-09-22
471 reads
A lot of these types of events are pulled together by the local user group. If there is none, it...
2016-08-31
721 reads
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
430 reads
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s...
2016-07-12
514 reads
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
689 reads
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced,...
2016-06-24
413 reads
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you...
2016-04-28
796 reads
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
793 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