Using Powershell to Deploy Performance Monitor
As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight...
2012-02-13
2,849 reads
Blog Posts
Debugging WP7s Isolated Storage
As part of the Windows Phone SDK you get the IsolatedStorageExplorerTool, this tool allows you to explore and update what...
2012-02-12
57 reads
How to hide Placeholder in SSRS 2008?
Introduction
For the ones who are working with SSRS, Placeholder is not new for them. So, today I will not go...
2012-02-11
8,205 reads
PASS Chapter Tools–My Wish List
I’m hoping this year will be the year that PASS makes a substantial investment in tools – the online kind – for...
2012-02-11
984 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
825 reads
A Script A Day - Day 10 - Hosts on vCentre
If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...
2012-02-10
713 reads
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,293 reads
Behemoth of the Server Room?
Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about...
2012-02-10
875 reads
Executing scripts with sp_addscriptexec
Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec...
2012-02-10
2,697 reads
Hardware Fun
This has been a bit of a hardware week for me, which is strange. I used to love hardware, building...
2012-02-10
1,094 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers