No More MCM
With the discontinuing of the MCM And MCA programs, Steve Jones has a few thoughts. This is the first of a three part series on certifications.
The Loss of Trust
The news about NSA spying keeps coming out, and apparently includes corporate communications as well.
SQL Saturday #250 Pittsburgh
September 14, 2013 Pittsburgh will be hosting a SQL Saturday. Join them for a free day of SQL Server training and networking. There will also be a paid pre-con session the day before on Performance Tuning in SQL Server 2012 presented by John Sterrett and Konstantin Melamud.
Using DAX to create SSRS reports: The Basics
You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.
Developer Pressure
As we ask developers to deliver software quicker, are we helping improve the quality of software? Steve Jones asks the question today.
SQL Server Error Log Scanning
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
SQL Licensing - What Managers Need to Know
PASS Professional Development Virtual Chapter will be hosting a session on what managers need to know about SQL Licensing, presented by Joseph D'Antonio on September 11, 2013.
SQL Saturday #244 Johannesburg
SQL Saturday is coming to Johannesburg, South Africa on Saturday, September 14 2013. Join us for a free day of SQL Server training and networking.
Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning
You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both.
Good and Bad Interview Questions
Are there good and bad interview questions? Are there some you prefer or hate? Steve Jones comments on some of the strange ones out there and how hiring is changing.
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