PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.
Security is always a hot topic, and Steve Jones notes that we should be specific when we work with security.
Where you have multiple services, applications and databases in your environment, and perhaps with high levels of scrutiny and governance, you'll probably want a Release Management system for deploying database and application code together: You can, alternatively, use a separate Release Management component. But for simpler applications, you can use your existing build system such as TeamCity to deploy changes. Using a database deployment example, Richard Macaskill shows how.
Today Steve Jones looks at the use of tracking sensors to gather spatial data on professional athletes for later analysis.
Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.
Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms. However the way in which they deal with such issues is quite different. In this article, Sergey Gigoyan explains the main differences between the two.
The first 100 people get to decide the data set. Give us the first thing you think of.
How can you fix a .NET Framework 3.5 error while installing SQL Server 2014?
There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective than using procedural code in triggers, procedures or application layers because it uses the SQL paradigm, thereby making optimisation easier and providing clearer expression of the rules underlying the data. Joe Celko explains.
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers