SQL Server 2012 (“Denali”): T-SQL Enhancements
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with...
2012-02-15
5,162 reads
Meme 15 - LinkedIn
The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn. I felt...
2012-02-15
404 reads
SQLRockstar's SQL Someday
http://vimeo.com/33411604
This is a talk given by Thomas LaRock (@SQLRockstar to you Twitter-folk) at an event last fall in NYC called...
2012-02-15
387 reads
Dynamic Add/Remove file in Mirroring/Logshipping
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
493 reads
SQL Server – DBA productivity and less is more
A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability...
2012-02-15
716 reads
Be careful with two digit years
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
770 reads
ANUG: Masters at Work
In November last year, our very own Henrik Sjang Davidsen did a session at the ANUG event called Masters at...
2012-02-14
1,022 reads
A Guide for Installing SQL Server 2008 R2 Reporting Services
Check out my article on SQLServerCentral.com in which I discussed SQL Server 2008 R2 installation setup which you can use to install...
2012-02-14
1,133 reads
ColoradoSQL–February 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-02-14
649 reads
Two Webcasts, One Day
If you are interested in listening to my sultry Minnesota voice this Thursday, you have the opportunity to do it…...
2012-02-14
639 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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