Changing SQLServerCentral - Newsletter Layout
Our series discussing the current and potential changes to SQLServerCentral.
Data Mining Introduction Part 6: Time series algorithm
This article is part of the Data Mining introduction series. This article is about time series.
Data Mining Introduction Part 6: Time series algorithm
This article is part of the Data Mining introduction series. This article is about time series.
Separation of Duty
We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.
An Introduction to Windows Azure BLOB Storage
Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows the basics of how to use it, from start through to snapshots and metadata; both from .NET, and by using the free tool, Cerebrata Azure Explorer.
SQL Saturday #240 Curacao
QL Saturday is coming to Curacao, Netherlands Antilles for a free day of SQL Server training and Networking on August 17. There will also be a pre-conference session on Practical Self-Service BI with PowerPivot for Excel.
Changing SQLServerCentral - Initial Thoughts
We have been considering lots of changes at SQLServerCentral, but we would like to get comments and feedback from the community as we move forward. This is the start of an series looking at potential and current changes.
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
Using Microsoft Excel to Retrieve SSAS Tabular Data
Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS tabular data into Excel. This provides an easy way of manipulating, visualizing and analyzing the data without needing to know the details of SSAS and the tabular model.
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