SQL Saturday #372 - Exeter, UK
SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.
Exploding the Myths of Big Data
As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.
Are There That Many GUIDs?
Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values.
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.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers