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)
6,027 reads
Chad Miller
Reconciling SPNs
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,406 reads
Sharing Profiles
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
Sarasota IT Pro Camp
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
Orlando IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,776 reads
Orlando IT Pro Camp
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
Importing CSV Files to SQL Server with PowerShell
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,490 reads
Some SQL Server Security Housekeeping
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,650 reads
Delegated SQL Server Administration with Powershell
Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks...
2011-11-07
2,631 reads
Gaining SQL Server SysAdmin Access
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,099 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers