Security Questions: TRUNCATE TABLE Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-30
1,704 reads
Ralph Kimball Books
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:
The Data Warehouse Lifecycle Toolkit: Practical...
2013-05-30
2,541 reads
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,379 reads
I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,279 reads
Saving Grace
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,253 reads
Backup a password, change it, then restore it.
A couple of months ago I talked about moving a login from one server to another without the password. The...
2013-06-05 (first published: 2013-05-30)
2,346 reads
SQL Saturday Charleston!
Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)
After the last SQL Saturday in Columbia,...
2013-05-30
1,910 reads
SQL Server security webinar series is coming soon!
I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...
2013-06-04 (first published: 2013-05-30)
2,542 reads
Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction
Recently I had to give a Power View demo for a client. Giving a demonstration means of course you have...
2013-05-30
2,953 reads
SSIS 2012 Deployment Fail Part Two: SSIS Server Maintenance Job
Recently I post about a timeout issue I was getting when deploying SSIS projects. It was mainly to do with too much log and previous versions being kept in...
2013-05-30
14 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers