Getting Excited: SQLBits is Coming!
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
858 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
Check the Default Database Setting for your Admin Accounts
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,780 reads
[Speaking] Lots of Speaking Engagements in September and October
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
756 reads
Pull Performance Data from Perfmon Logs with PowerShell
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,297 reads
[OT] On Community
Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...
2011-08-11
615 reads
[Speaking] Presenting at AITP Region 18 IT Con
The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an...
2011-06-16
761 reads
Use PowerShell to Add a Login to a Database Role in all Databases
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
5,958 reads
What Encryption Algorithms Are You Using?
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,098 reads
Endpoints Need Privileges Too
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,266 reads
Monitor your SQL Server Agent Proxies Using PowerShell
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,184 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
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...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
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