SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
2012-02-29
3,032 reads
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
8,635 reads
2012-02-28 (first published: 2010-10-20)
9,599 reads
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
2012-02-28
3,400 reads
Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.
2012-02-27
23,291 reads
SQL Server backups are key to recovering from a disaster or some type of data failure, but the real magic happens when the backup is restored. In this tip we look at a new enhancment in SQL Server 2012 for point in time recovery using the new timeline feature.
2012-02-27
3,196 reads
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
2012-02-27
1,360 reads
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
2012-02-27
1,265 reads
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
2012-02-24
7,239 reads
There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues.
2012-02-24
3,549 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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...
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