A Hazard of Using the SQL Merge Statement
The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned
Data Darwinism
Data could be the way that more decisions are made, separating the competent from the incompetent in the future. Steve Jones isn't sure this is the best way to make decisions if we don't include a human element in the decision process.
Expand Your Skills at the PASS Business Analytics Conference
Join top business intelligence and analytics experts in Chicago April 10-12 for 60+ sessions on the best practices, prescriptive guidance, and strategic vision you need to get the most from your data. Use code BACSSC to save $250 today!
Join Reordering and Bushy Plans
Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from other joins. This means that it won't produce good query plans for some types of query. Hints, by themselves won't do it. More powerful magic is required.
Low Profile Architecture
The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.
Salaries in 2013
The release of an extensive salary report for Information Technology shows some good trends in it for 2013.
SQL Saturday #203 - Boston
Join us at SQL Saturday Boston on April 6th. SQL Saturday is a free training event for SQL Server Professionals and those wanting to learn more about SQL Server.
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions
n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?
Google Glass Your Database
A new idea from a small startup may revolutionize the way that you search for data.
NoSQL: Are you ready to compromise with security
Before adopting NoSQL for a commercial application that needs consistency and durability, you need to be satisfied that the product actually provides all those niceties that the user of relational database systems take for granted.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers