Identifying Start Dates not Aligned with End Dates on a Prior Row
When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?
Database source control workshop, Cambridge UK
Redgate is hosting a 1 day public workshop on April 22, 2015. This workshop will teach you how to put a database in source control, deploy a database from source control, and monitor database changes across development, testing, and production environments.
Integrating Database Lifecycle Management into Microsoft's Application Delivery Process
In order to automate the delivery of an application together with its database, you probably just need the extra database tools that allow you to continue with your current source control system and release management system by integrating the database into it. If you're using the Microsoft stack, then Redgate's tools can help with some of the difficult database parts of the process, as Jason Crease demonstrates.
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
SQL Cop and SQLServerCentral
Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.
SQL Server Reporting Services Bookmarks and Document Maps
What are the SQL Server Reporting Services Document Map and Bookmark properties? How can they be used? Do they work for all rendering formats? Scott Murry answers these questions and more.
Azure Blob Storage Part 8: Blob Leases
In this article, Robin Shahan explains what Blob Leases are and how to use them, including code samples for calling the different methods available for managing Blob Leases.
Mail Fails with SQLCMD Error
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
Microsoft and R
R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers