What does that N in nvarchar really mean?
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,398 reads
Kenneth Fisher
‘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
511 reads
What is the current database context?
Every now and again it can be very helpful to know what the current database context is when you are...
2015-12-21
682 reads
Can we get a license for DDL Triggers?
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,702 reads
Scripting out multiple scripts from the Object Explorer Details window.
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...
2015-12-16
603 reads
DBA Myths: Database file extentions
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,349 reads
Using unique constraints
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...
2015-12-10
1,639 reads
Apathy – A quick path to the naughty list.
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
535 reads
You should always have an “I got hit by a bus” backup plan
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,457 reads
Using multiple log files
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,565 reads
Blogs
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers