Automated Permissions Auditing With Powershell and T-SQL: Part 4
Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...
2013-11-18
1,067 reads
Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...
2013-11-18
1,067 reads
Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...
2013-11-16
426 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
490 reads
In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.
DISCLAIMER: I...
2013-11-14
3,553 reads
In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within...
2013-11-13
581 reads
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
646 reads
A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...
2013-11-11
1,056 reads
Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter
Over the past few months, I’ve been doing a lot of work...
2013-11-19 (first published: 2013-11-09)
2,013 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-08
450 reads
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
942 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers