Stairway to Database Design
A series by Joe Celko that examines the craft of designing a database to meet your needs.
2010-12-06
12,950 reads
Articles
Signal Waits and Resource Waits...a clarification
Signal Waits vs. Resource Waits
During my presentation at SQLSaturday#59, I spoke about the categories of wait types, such as...
2010-12-06
3,713 reads
Uninstalling a SQL Server Clustered Instance
I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?
2010-12-06
3,572 reads
SQL Server 2005 Performance Dashboard Using SSRS
A first look at the Performance Dashboard in SQL Server 2005 by new author Robert Griffin.
2010-12-03 (first published: 2009-07-29)
28,470 reads
3 Fundamental Questions about Data Marts...and Their Answers
A data mart provides the primary access to the data stored in the data warehouse or operational data store. It is a subset of data sourced from the data warehouse or operational data store specifically focused on a business function or set of related business functions. Read on to learn the answers to fundamental questions about data marts.
2010-12-03
5,164 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-12-03
3,056 reads
Plays Well With Others – Eight Behaviors of Excellent Leaders
Last week, I talked about one of the worst type of management scenarios to work under – the micromanager. Now, let’s...
2010-12-03
2,401 reads
SQLServerCentral Webinar Series #4: How to Monitor your SQL Servers
You can monitor your servers with the new SQL Monitor software from Red Gate Software. MVP Brad McGehee showed how the SQLServerCentral servers are being monitored publicly. The slide decks and Q&A transcript at available.
2010-12-02 (first published: 2010-11-09)
4,765 reads
Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
2010-12-02
2,606 reads
SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers