We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?
Does your IT organization bring value to your company? Steve Jones takes a look at some of the ways you can do this. This editorial was originally published on July 2, 2008. It is being re-published as Steve is at SQL Intersection.
Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.
Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.
Sometimes auditing for one certification might help you pass another, but don't count on it.
A new memory technology has the potential to dramatically speed up access for computer systems.
Join us at SQL Saturday Costa Rica on April 13, 2013 for a day of SQL Server Training and Networking.
You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
This article explores the place of emotion among knowledge workers doing team-based design activities.
The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers