Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,432 reads
Blog Posts
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,391 reads
Workaround Primary Key Violations in SSIS
Before you get much further, please do not use this for every case where you have issues with duplicate rows....
2008-11-26
1,520 reads
Airlines Don't Care About Customers? Nor Does The Government!
I saw this post about a recent panel that tried to come up with guidelines for airlines as far as...
2008-11-25
1,388 reads
Catching Up
My goal of 400 posts a month has been in jeopardy with all the traveling I've been doing over the...
2008-11-25
1,479 reads
PC Magazine Going out of Print
Saw a post from Michael Miller that PC Magazine will end it's print version with the January issue. Have to...
2008-11-25
1,540 reads
Spend Money to Make Money
One of those old sayings that has a grain or two of truth to it. Stocks, real estate, education even,...
2008-11-25
1,561 reads
The Advantage of Seattle - Where to host the PASS Community Summit
I heard during last week that the 2009 PASS Community Summit will be back in Seattle, on Nov 3-6 next...
2008-11-25
1,568 reads
Digging into Replication
It's fun to read good work, and my friend Kendal Van Dyke recently posted How CommitBatchSize And CommitBatchThreshold Affect Replication....
2008-11-24
1,412 reads
Immersed in work, and missing out on everything else
After 2 years working on a data conversion and software implementation project, I’ve finally started to get caught up on...
2008-11-24
1,664 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
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
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 n;See possible answers