SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...
2012-05-31
3,798 reads
Blog Posts
Turn on Instant File Initialization for SQL Server Performance – With Video Demo
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,811 reads
Denali – Day 30: Deprecated Features
Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but...
2012-05-30
2,662 reads
Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,130 reads
Syncing your calendars
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my...
2012-05-30
1,968 reads
Turn on Instant File Initialization for SQL Server Performance
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-30
4,369 reads
Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,115 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,653 reads
Oracle Date issues with PowerPivot
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,275 reads
SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,758 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers