Ctrl+R in SSMS 2012
After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like...
2012-08-14
6,395 reads
Blog Posts
Database and Disk Size - PowerShell Script
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
6,047 reads
Database Certificates and the X.509 Standard
Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...
2012-08-14
1,089 reads
Drive Size - PowerShell Script
The below script is used to find the disk size for a set of servers,
## Script to Find List of...
2012-08-14
2,010 reads
First Try at a Wooden Hand Plane
I’ve been reading about wooden hand planes lately (as opposed to hand planes made of metal that plane wood) and...
2012-08-14
893 reads
Fix: Crystal Reports Shows Red X Across Entire Page When Report Run Inside Visual Studio
I was googling (with Bing AND Google) like crazy for a solution to this, but didn't find one from any...
2012-08-14
2,049 reads
Modify Host File on Windows 7
Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...
2012-08-14
1,197 reads
Speaking at PASS Summit 2012
It’s Not A Repeat
Speaking at the PASS Summit last year was one of the highlights of my career. I had...
2012-08-14
739 reads
Speaking Tomorrow for Professional Development VC
As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will...
2012-08-14
1,139 reads
Travel Plans for PASS-Done!
I’m flying in on Sunday again this year, arriving in time for lunch, and looking forward to the luxury of...
2012-08-14
618 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers