Automated Permissions Auditing With Powershell and T-SQL: Part 3
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,525 reads
Blog Posts
Baseline Maintenance Statistics Job For Indexes. (say that three times fast)
This is a project I've been working on for a while. The information is all there... how it's queried may...
2013-11-14
504 reads
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
919 reads
Free Online SQL Server Training for the Week of November 17, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-14
2,226 reads
Free Online SQL Server Training for the Week of November 17, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-14
454 reads
2013-11-14
659 reads
New Book: Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services
I’m very excited to announce that you can now purchase my latest book: Building Performance Dashboards and Balanced Scorecards with...
2013-11-14
1,918 reads
Powershell in a Month – Day 2, Help
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a...
2013-11-14
1,248 reads
Querying Microsoft SQL Server: T-SQL
Querying Microsoft SQL Server: T-SQL: T -SQL is advancement of SQL. It include procedural programming, local variables , various support functions for...
2013-11-14
1,176 reads
SQL Server Data Tools BI (SSDT-BI) for SQL Server 2014
Last month I blogged that SQL Server Data Tools for SQL Server 2014 CTP2 now available. You can download that here....
2013-11-14
4,892 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers