New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
2003-05-05
22,291 reads
As LockwoodTech Log Navigator Beta releases approaches we have released a bunch of new screen shots on product features. Log Navigator reads the MS SQL Server Transaction Log to allow you to passively audit data changes (inserts, updates and deletes) made to your database.
2003-05-05
619 reads
Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.
2003-05-02
17,122 reads
Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included
2003-05-01
2,698 reads
Brian spends a lot of time in our forums helping out. Based on a recent question from a reader he put together some tips he used when he was preparing for the MCSE exams. Interesting reading!
2003-04-30
9,905 reads
SecureWave forwarded us this link to some info about their product - they claim to be the only product capable of protecting SQL Server from buffer overflow attacks. You can download a free eval from their site. We have not reviewed this product.
2003-04-29
1,001 reads
Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!
2003-04-28
10,360 reads
Another link from Steve Jones, this page has a great breakdown of the different types of RAM.
2003-04-24
808 reads
This white paper was written by Alain Dumas, founder of Sunopis. Looks interesting. Looks like they sell a tool that does ETL, replication, data cleaning, and more. We haven't reviewed the product, just thought it was something that might be of interest to our readers
2003-04-22
1,023 reads
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
2003-04-21
7,069 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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