The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s...
2016-03-11 (first published: 2016-03-02)
2,336 reads
It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited...
2016-03-08
1,169 reads
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again)...
2016-03-04 (first published: 2016-02-29)
1,261 reads
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,088 reads
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...
2016-02-23 (first published: 2016-02-17)
3,982 reads
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...
2016-02-22
1,164 reads
The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?)
varchar(1) Really? It’s...
2016-02-15
1,646 reads
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
589 reads
I use impersonation all the time to let me see additional permissions information I can only get that way and,...
2016-02-08
482 reads
Every now and again you need to run code when your instance starts up. For example you might want to...
2016-02-08 (first published: 2016-02-01)
1,486 reads
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Packing and Decoding Device Status...
Comments posted to this topic are about the item 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