SQL and Scope
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
2019-10-24
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
2019-10-24
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
2019-08-01
Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot of time figuring out what the schema should be for the target table. In this article, Rodney Landrum demonstrates an interesting solution to automatically figure out the data types and un-nest delimited data.
2019-07-08
Adopting standardized processes in database development can free up the time of development teams for innovation and value adding work. Find out the 4 steps you can take to lay the foundations for standardized development in your team and pave the way for full automation.
2019-05-29
Working in a dedicated database model is the ideal. So, what does it take to move from shared development to a dedicated model? Infrastructure costs, merging multiple changes and maintaining an increased estate might be on your list of things to consider before committing to the switch. In this article we show how Redgate tools can ease the transition and new working approach.
2019-04-11
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
2013-03-14
4,602 reads
By alevyinroc
It’s been a minute since I’ve gotten out to speak at events, but the...
By Steve Jones
The PASS Summit goes on tour this year, with an August stop in New...
By Kevin3NF
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...
Dear All, Good Day. I have a requirement to implement de-duplication on customer data...
Comments posted to this topic are about the item Own Your Mistakes
Comments posted to this topic are about the item Automating SQL Server Inventory Collection...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers