Learning the SQL GROUP BY Clause
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
2021-10-06
T-SQL
How LAG compares to other techniques
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
2021-09-24
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON
This article will demonstrate how to migrate via JSON, key-value pairs from a Python dictionary object to a SQL Server table.
2021-07-16
Mergers and acquisitions in Insurance
The insurance sector has seen a marked rise in mergers and acquisitions over the past 12 months, and although these can be an excellent way to leap beyond organic growth, M&As can result in challenges with technology. In this blog, COEO's James Boother provides some tips on how, with good planning, technologies can be a real advantage in your next acquisition.
2021-07-14
What does SET NOCOUNT ON do?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.
2021-07-05
Opening JSON Data with T-SQL
The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.
2021-06-25
SQL Server Resource Governor Game
Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.
2021-06-09
SQL Server T-SQL CASE Statement Examples
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
2021-05-14
Never, Ever, Ever Start T-SQL Comments with Two Dashes
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
2021-04-26
Blogs
Alert Filtering in SQL Monitor
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
SharePoint List only returns 100 items in Azure Logic App
I was reading a SharePoint List using the “Get Items” activity in an Azure...
Daily Coping 27 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Database backup and restore
Hello, I've a user database which I want to migrate to new server, so...
Help Implementing Sample SQL Code
Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...
Error restore database in AZURE
Hello everyone, I created my SQL server Azure in PASS when i try to...
Ask SSC