Creating Sparklines in PowerPivot
Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2. In this post I will outline the steps...
2010-05-09
2,531 reads
Blog Posts
Report Parameter order in SSRS
Is the order of parameters important in SQL Server Reporting Services reports? If you’ve got nested parameters (parameters that derive...
2010-05-08
2,602 reads
2010 1st Quarter Goals Review
I know it’s kind of late to write a review of my first quarter goals, since we are well into...
2010-05-07
1,096 reads
Colorado Springs SQL Server User’s Group Meeting on Wednesday, May 19, 2010
The Colorado Springs SQL Server User’s Group is having their May meeting on May 19.
It will be held at the...
2010-05-07
695 reads
Daily SQL Server 2008 New Feature – Day 2
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-07
739 reads
Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,304 reads
DBAs – soon to disappear??
Heres a thought
With all the monitoring tools and performance gauging software available on the market these days, will there ever...
2010-05-07
595 reads
Denver SQL Server User’s Group Meeting on Thursday, May 20, 2010
The Denver SQL Server User’s Group will be having their May meeting next Thursday, May 20. As always, the meeting...
2010-05-07
500 reads
Log Shipping Problem
Log Shipping Issue (encountered by Abi Chapagai May 7th)
I had set up log shipping between two servers few weeks ago....
2010-05-07
7,603 reads
My experience while writing for SQL Server Standard magazine
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
820 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
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...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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