Interactive Parameter Selection with Reporting Services
Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI
Naming Confusion
The naming of systems and other technological constructs is always a debate within groups. Steve Jones points out a few places where this might actually prevent mistakes.
PCI Best Practices Guide for SQL Server DBAs
Tibor Nagy has put together some best practices to help SQL Server DBAs navigate the many different requirements around PCI compliance.
Controlling Alerts
Being on call is not much fun for anyone, but it can certainly be hard on those that receive lots of calls for systemic issues. Are there better ways to manage this?
DevOps and the DBA
Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can’t just automate all your problems...
Free Guide: Eight Steps to Effective SQL Server Monitoring
This free guide includes worked examples, practical advice, and covers the hows and why of SQL Server monitoring. Download the guide and get a 26 monitoring tips as well.
A Complex Database Project in Visual Studio SSDT
One Way to Handle a Very Complex Database Project with Several Databases and Cross References
Database Source Control Workshop - London, UK
Redgate's workshops are coming to London on July 8, 2015. In this workshop, you'll learn how to source control your database, deploy your databases from source control, and monitor and track database changes across development, testing, and production environments. Register while space is available.
Testing SQL Server Backup Performance with Trace Flag 3042
Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.
Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
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