Boorish Behavior? No, Worse. Death Threats Against Developers/Designers.
I know DBAs and developers have a rocky relationship. However, I don't believe we go as far as some of...
2013-08-16
834 reads
Cannot find NT Service\MSSQL$SQL2012?
If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...
2013-08-16
1,214 reads
SQL Server 2014: AlwaysOn
AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
Now support up to 8 secondary...
2013-08-15
2,150 reads
Azure and Your MSDN Account
I’ve heard over and over again that the reason people don’t want to learn Azure, to explore it, to understand...
2013-08-15
754 reads
Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"
In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:
TITLE: Configure...
2013-08-15
12,039 reads
Interview Candidates for Skills, Aptitude, Maybe Both
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,450 reads
Schneier's Thoughts on the Future of IT Security and the Impact of the Internet on Power
If you've got an hour to spare, you might want to check out this presentation by Bruce Schneier where he...
2013-08-23 (first published: 2013-08-15)
1,667 reads
Quick tip: WMI alerts and SQL Server Agent permissions.
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,610 reads
Join me for the 2013 Biml Workshop
Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml. If you’re not familiar...
2013-08-21 (first published: 2013-08-14)
1,260 reads
Configuring BIDS 2008 / 2008 R2 and Visual Studio 2008 to work with Database & Business Intelligence Projects and Team Foundation Server (TFS)
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,695 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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