Creating a Data Mining Reporting Services Report - SQL School Video
In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.
Generate a SQL Server Instance Inventory
How many times has someone asked you to determine how many instances of SQL Server are installed on your network? New author Sakthivel Chidambaram brings us a few tricks for keeping track of those installations.
Positive Blogging
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
Administrator & Monitoring Change Data Capture in SQL Server 2008
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008
Capturing SQL Server 2005 database file size information
It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information.
How Important Is Usability?
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
How Important Is Usability?
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
How Important Is Usability?
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
SSIS 2008 Data Profiler
Business Intelligence expert Vincent Rainardi brings us a new article that looks at how you can profile your data to understand its values and distribution using Integration Services.
Positive Blogging
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
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