Tools to Monitor Performance of SQL Server
To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...
2012-02-16
3,221 reads
Blog Posts
Comparing Inline and Multi-Statement Table-Valued Functions
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,913 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
Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”
Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will...
2012-02-15
1,669 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
PASS Data Arch VC presents Steve Simon - On Beyond Zebra AdventureWorks OR Where Did I Go Wrong?
I meet Steve when he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...
2012-02-15
744 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
SQL Server 2012 (“Denali”): Contained Databases
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure,...
2012-02-15 (first published: 2012-02-13)
2,936 reads
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
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
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...
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