SSMS and scripting
I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting...
2006-11-28
1,368 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Default schema
Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of...
2006-11-27
1,402 reads
Back from PASS
While at PASS, I created a thread in the forums: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=322277 . It was an incredible week. I look forward to...
2006-11-20
1,311 reads
PASS
My daughter-in-law just reminded me on Sunday that her birthday was in 21 days. Yikes! That's the day I fly...
2006-10-26
1,314 reads
Writing Simple Select Statements - Part 3
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
Writing Simple Select Statements
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
Jumpstart TV Video
If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use...
2006-09-11
1,585 reads
RegCreateKeyEX() error
I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I...
2006-03-27
2,934 reads
PASS 2006 Call for Presentations
For those of you who are interested in speaking at PASS in November, the submission site is open: http://passew.prod.web.sba.com/callpapers/CallPapers.cfm?conference_id=15 .
I encourage...
2006-02-09
1,305 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
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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