Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,571 reads
SQLDownSouth
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-05
536 reads
SQL Lunch #7 – Top Tablix Tips
SQL Lunch # 7 – Top Tablix Tips
Speaker: Jessica Moss
Topic: Top Tablix Tips
Add to Outlook: Add to Calendar
Description:
SQL Server Reporting Services 2008...
2010-01-04
1,456 reads
Deploying Reports on Windows Seven
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-12-22
503 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-22
2,051 reads
SQL Lunch # 5 – Looping Logic in SSIS
SQL Lunch # 5 – Looping Logic in SSIS
Speaker:Tim Mitchell
Topic:Looping Logic in SSIS
Meeting URL:JOIN MEETING
ADD TO OUTLOOK CALENDAR
Description:
Software developers have long taken...
2009-12-11
999 reads
Baton Rouge SQL Server User Group - Overview of Business Intelligence
Topic
An Overview of Business Intelligence
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCPresenter
Brandon McMillon
Brandon McMillon...
2009-12-01
564 reads
December 2009 – Baton Rouge SQL Server User Group
December SQL Server User Group Meeting
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCTopic
An Overview of...
2009-12-01
501 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
2009-12-01
7,773 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features.One key feature was the inclusion of the Gauge Controls.I was recently...
2009-11-30
1,731 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
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