SQL Saturday Precon - SSIS Design Patterns
SQL Saturday is hitting Dublin for the first time on March 24th.
2012-03-20 (first published: 2011-12-23)
5,627 reads
Articles
Tips for Upgrading a Cluster to SQL 2008 - Part 2
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2012-03-20
2,434 reads
SQL Server Ranking Functions
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
2012-03-20
3,874 reads
Financial Rounding of Allocations
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
5,947 reads
TSQL Challenge 78 - Parse single field into multiple fields
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
2012-03-19
2,624 reads
SQL Saturday #128 - Istanbul
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
2012-03-19
1,391 reads
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
2012-03-16
3,321 reads
Adding a log shipping monitor
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,173 reads
Using The AlwaysOn Feature of SQL Server 2012
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
2012-03-15
3,949 reads
Basics of XML and SQL Server, Part 2: Shredding XML
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
2012-03-14
18,223 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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