ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
522 reads
Blog Posts
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
15 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can use and where you use different types is unclear,...
2015-11-03
7 reads
SQL New Blogger Challenge, Week 1: Just write!
It’s already time for week 1 of this round of the SQL New Blogger Challenge! I have to admit that...
2015-11-03
369 reads
The Whirlwind That Is October – Part 3
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
510 reads
Where’s my Team Explorer 2015?
Team Explorer is a client software that can be used to integrate Visual Studio with an instance of Team Foundation...
2015-11-03
414 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-11-02 (first published: 2015-10-21)
2,411 reads
Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
506 reads
Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-11-02 (first published: 2015-10-21)
5,385 reads
Hekaton Part 10: Things Hash Indexes Can do
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
488 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