"What You Need To Know About Being a DBA and What You Need To Know That You Don’t Know Yet"
Last night was a big success for the first annual Baton Rouge User Groups Networking Night, an all-user-groups invited event...
2014-07-10
614 reads
Will Assaf
SQL Saturday Baton Rouge 2014
Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since...
2014-07-10
703 reads
Baton Rouge SharePoint Saturday 2014: SQL Server Best Practices for SharePoint Databases
Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!
Here is my presentation for the 1:15 presentation in...
2014-06-21
634 reads
Baton Rouge SharePoint Saturday
I'm thrilled to be joining many of my colleagues at Baton Rouge SharePoint Saturday this weekend at the Louisiana Technology...
2014-06-16
548 reads
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,159 reads
Real heavyweights: Float vs Decimal, the Thrilla in Precision
This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I...
2014-05-01 (first published: 2014-04-23)
2,955 reads
South Alabama Day of .NET Presentations Downloads
I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...
2014-03-29
1,194 reads
South Alabama Day of .NET 2014
About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long...
2014-03-27
735 reads
Challenges with Downgrading TFS 2010 from SQL Enterprise to SQL Standard Edition
I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,891 reads
Data Architecture Virtual Group - Whiteboard Data Architecture Presentation
Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the...
2014-02-27
1,296 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