What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
609 reads
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
609 reads
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,850 reads
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,266 reads
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
943 reads
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask...
2015-08-28 (first published: 2015-08-19)
2,810 reads
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule....
2015-08-26
652 reads
The other day I was asked to pull a list of errors from the SQL Server log into a table...
2015-08-25 (first published: 2015-08-17)
2,961 reads
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
635 reads
Earlier today I was working on a project where I was recording some time stamps. In order to get as...
2015-08-13
573 reads
Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first...
2015-08-11
798 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