SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
2010-09-14
1,240 reads
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
2010-09-13
1,817 reads
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
2010-09-13
13,650 reads
SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.
2010-09-13
3,345 reads
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010
2010-09-13 (first published: 2010-09-02)
1,529 reads
2010-09-10 (first published: 2008-11-17)
33,032 reads
Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.
2010-09-10
4,388 reads
SQL Saturday Columbia, SC gives you a chance to get a full day of free SQL Server information, lectures, and seminars from the experts on the East Coast.
2010-09-10
1,014 reads
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
2010-09-09
7,864 reads
Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
2010-09-09
1,099 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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