Transforming Event Log Data
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
5,995 reads
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
5,995 reads
As part of troubleshooting Kerberos authentication for SQL Server I had to verify SPNs so I thought I’d blog about...
2012-02-20
2,337 reads
A question came up in a class I was teaching: “How do you share your Powershell profiles across accounts?”
Well, there’s...
2012-02-11
791 reads
Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies...
2012-02-04
924 reads
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,776 reads
The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro...
2012-01-10
979 reads
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off another guest blogger week (Nov 28th 2011) with my guest blog...
2011-11-28
3,419 reads
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,648 reads
Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks...
2011-11-07
2,619 reads
I’ve seen this come a few times at work and I’m sure most you have experienced something similar.
Someone or an...
2011-10-22
4,066 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
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