‘Twas 4:45 Friday
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents...
2015-12-23
498 reads
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents...
2015-12-23
498 reads
Every now and again it can be very helpful to know what the current database context is when you are...
2015-12-21
664 reads
There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...
2015-12-17 (first published: 2015-12-14)
1,688 reads
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...
2015-12-16
575 reads
Every now and again I hear or read that the only file extensions for a SQL Server database are mdf,...
2015-12-10 (first published: 2015-12-02)
2,299 reads
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...
2015-12-10
1,615 reads
It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really...
2015-12-08
520 reads
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...
2015-12-07 (first published: 2015-11-30)
2,448 reads
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,538 reads
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
625 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers