Spreadsheet controls in #Office 2013
Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help...
2014-02-21
598 reads
PowerShellGUI Tools – Disk,Memory and Process – Modules
I’ve created a script which gives details of Disk, Memory and Process and its represented graphically.
Here, the scripts are enclosed in...
2014-02-20
1,732 reads
Virtual Lab – Creating Differencing Disks
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-02-20
1,180 reads
McIntosh MT5 #stayclassysandiego
Making or assembling electronics in America may be the next big trend in tech, but it’s nothing new for McIntosh....
2014-02-20
436 reads
Annoying Recruiters
In a follow-up to my blog post Low-rate recruiters – The bane of my existence, Michael Bramante (website) wrote me a...
2014-02-20
1,305 reads
Sometimes Cheaper Makes Sense / Mastering the Basics Always Does
It’s good to remember that the ideas and challenges of mastering a craft – any craft – have been around a while....
2014-02-20
654 reads
Restoring Filegroup backups on another server, and why it won’t work…
We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.
One of...
2014-02-20
676 reads
The Strange Story About the MERGE that Killed the Cluster
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...
2014-02-20
4,406 reads
101 Whiskies to Try Before You Die #whiskey
In his new book “101 Whiskies to Try Before you Die” whisky expert Ian Buxton poses the fun challenge of...
2014-02-20
717 reads
Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.
When I try to attach mdf file I got following error below.
Solution:
There are multiple solutions to this
1 1. Move .mdf and .ldf to SQLServer install directory Data folder...
2014-02-20
58 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