Connection Strings 101
This article introduces connection strings and suggests using MDAC to easily write efficient connection strings for those new to SQL Integration.
Call in the Experts
Today we have an editorial from Feb 1, 2006 that is being reprinted as Steve Jones is on vacation. Steve talks about the need to call in a friend to check on the performance of the SQLServerCentral servers.
FREE! SQL Scripts Manager – a Christmas gift from Red Gate
Red Gate has released SQL Scripts Manager, a free tool containing over 25 scripts written by SQL Server experts, to help you automate common troubleshooting, diagnostic, and maintenance tasks.
Queries for SSC Community Participation
Bill Nicolich uses T-SQL to look at the community participation of people at SQLServerCentral.
Linqpad and Autocompletion
I have mentioned before about doing development for StreamInsight in Linqpad. I have it installed on two separate PCs and I have enabled autocompletion on only one of them. Whilst both versions are an excellent tool, the one with autocompletion enabled is so much easier to use. After enabling autocompletion you can see I now get parameter listing
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
Calling Out Bad Advice
Today we have a guest editorial from Tim Mitchell that asks how we should handle bad advice given on the Internet.
Fun with SQL Server Profiler trace files and PowerShell
Running Profiler traces against multiple servers becomes a painful process when it’s time to collate and filter all that data. It would be time-consuming, frustrating and messy if Laerte hadn’t written this handy PowerShell script (complete with examples) to help you out.
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
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers