sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
695 reads
SQLStudies
Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,339 reads
I don’t want to grant permission to all the tables in the database at once.
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,166 reads
What is this default trace you speak of?
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
842 reads
MJ Swart offers free technical editing
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
888 reads
15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,054 reads
What is the difference between Money and Decimal(19,4)
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
2,012 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,644 reads
Microsoft’s free virtual labs
If you have spent any time looking around my site, you will notice that I love study materials and in...
2014-05-26
1,181 reads
DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,650 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers