This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of my tasks is to create a Speaker’s Resource page on the SQLPASS.org website to aid speakers who want to submit session abstracts for the 2009 PASS Summit, which will be held in Seattle, WA from November 3 — 6, 2009.
SQL Server 2005 system views and Reporting Services are combined to break down tempdb utilization into its individual components in real time.
In the news this week, Microsoft is cutting some licensing costs for larger companies. A good move for them as the economy slows.
In a previous blog post on Detecting When a Login Has Implicit Access to a Database, I mentioned that having CONTROL SERVER rights means having implicit rights into the databases. Robert Davis posted a comment asking if there was a difference with respect to explicit permissions between being a member of the sysadmin fixed server role and having CONTROL SERVER rights.
If you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
Operations Manager has a number of reports to help you monitor the uptime of your applications, but reporting can be difficult to learn until you understand all the different options, the different parameters possible, and the way the Operations Manager health model is structured. Firstly, you need a clear idea about the way that your organization defines 'uptime'. then you can start your reports from any of the views in the Monitoring tab, and then add or remove objects to get the report you need.
Having employees leave your company is a reality of life. But how do you handle letting your IT workers go and protect your systems? Steve Jones isn't sure there is much you can do to prevent issues, but you can deal with them.
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
When the schema of an object is changed, SQL Server wipes out the previous...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers