Storing a Binary File in a Database
In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.
SQL Monitor Custom metric: Average I/O stalls
This is a good general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.
Webinar: How to safely manage application and database changes with continuous delivery
Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.
The Cascading (CROSS) APPLY
An old trick nowadays but one which is still underused here on SSC is the cascading CROSS APPLY – where output from one CROSS APPLY is used as input for another.
Optimizing Batch Process in SQL Server
SQL Server batch processes are usually run from SQL Agent in the background. Often, the responsibility for creating these tasks belongs entirely to the developer. Dennes Torres demonstrates that DBAs can advise and assist with this type of batch job to help reduce their impact on the working system.
Big Data for SQL folks: The Technologies (Part I)
Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.
Native Audits
This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.
Database Continuous Integration Workshop - London, UK
Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.
Developer-Tester Relationships
In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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