Finding gaps or missing dates in a date range using TSQL
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,352 reads
MarlonRibunal
- Twitter: @MarlonRibunal
- Website: https://marlonribunal.com
How to resequence column based on numeric prefix using TSQL
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...
2015-03-26 (first published: 2015-03-19)
6,315 reads
Getting back to basics
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
614 reads
Executing scripts on multiple servers the easy way
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,392 reads
Failed To Lock Virtual Machine’s Configuration
[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...
2014-05-23
14,769 reads
Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,677 reads
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,152 reads
My First Book: SQL Server 2012 Reporting Services Blueprints
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,305 reads
Virtual SQL Playground Adventure: Introduction
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,486 reads
Connecting Windows Server 2003 VM To External Network In Hyper-V
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...
2013-05-31 (first published: 2013-05-24)
4,796 reads
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