SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.
2014-10-09
7,670 reads
2014-10-08
615 reads
You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.
2014-10-08
10,150 reads
When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.
2014-10-07
9,444 reads
To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.
2014-10-07
8,227 reads
Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
2014-10-06
9,461 reads
Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.
2014-10-06
8,060 reads
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
2014-10-03 (first published: 2012-07-02)
27,924 reads
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
2014-10-03 (first published: 2014-09-29)
501 reads
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?
2014-10-03
9,305 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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