sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
894 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
894 reads
So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an...
2014-01-13 (first published: 2014-01-06)
6,603 reads
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,381 reads
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
631 reads
On the first day after release my developer gave to me
a performance problem on a crucial query
On the second day...
2013-12-24
784 reads
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
680 reads
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
648 reads
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,509 reads
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....
2013-12-10
848 reads
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...
2013-12-09 (first published: 2013-11-27)
3,148 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
Hello all, I would like to create an INSERT statement and use a UDF...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers