Version Control your Stored Procedures
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
SQL Server Management Features vs Oracle Database Management Features
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.
Finding Jobs
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
Good Enough
When is it worth making an investment to learn a new technology? Steve Jones comments on Powershell as one of those technologies that he has been slow to begin using.
SQL Saturday #38 - Jacksonville
Come attend this great one day free event on the Florida coast on May 8, 2010. There are a number of great speakers that make this worth attending.
SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.
Calling exceptional DBAs: step up and be recognized
Nominations for The Exceptional DBA of 2010 open today, giving database administrators around the world the chance to be recognized for service to their employers, the SQL Server community, and the IT industry at large.
Improving Performance of Cross-Partition Queries
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
This Can't Happen
A bug reported on Connect has Steve Jones worried. This one could be a big deal in some situations that are concerned about comprehensive auditing.
The Com.PASS Feeds
A new set of RSS feeds, hosted by PASS, bring you a large quantity of SQL Server content from various sites, including SQLServerCentral.
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers