Complete Definitions
When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.
How to FTP a Dynamically Named Flat File
Learn how you can dynamically name a file in SSIS and then send it using the FTP task.
MongoDB vs. Azure DocumentDB
There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?
Finding Problem Code
This week Steve Jones has a poll on performance tuning code. Since many people aren't experts, the answers this week might help them learn where to focus their efforts.
The new Analytic functions in SQL Server 2012
SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
Automated database deployment workshops
Redgate is offering a 1-day public workshop for anyone who’s interested in automated deployments for SQL Server databases. In the hands-on exercises, you’ll learn how to deploy with PowerShell and Octopus Deploy, work with NuGet packages, handle unexpected changes in your production database (database drift), test your changes with dry run releases, add review and rollback steps, check your deployments have worked, and how to fix things if your deployment fails. Find a workshop near you.
CONCAT and STUFF Functions in SQL Server 2012
The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.
Is It Time to Upgrade?
Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.
SQLServerCentral Runs sp_Blitz - The Future
After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.
Microservices in Promise and Practice
Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers