Data Security and AI
Today Steve discusses an aspect of AI that many people are concerned about: data security. Read more and think about how this might affect your organization.
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
Time Series Data Mining Example with T-SQL when Adding New Data
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
You Are An Inspiration
Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, […]
Comparing Two Execution Plans
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]
Black Friday returns to SQLServerFast
November approaches again. For Europeans, that is a month like any other, for Americans, November means: Black Friday, with huge discounts!
Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
Blogs
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Comparing Two Scripts with kdiff3
By Steve Jones
I had a customer recently ask if SQL Compare could show them the differences...
Forums
Error while opening a custom report(.rdl) in SSMS 2017, created in VS 2019
I'm experiencing difficulties opening a custom report created in Visual Studio 2019 using Microsoft...
activity monitor is showing two diffrent spid for one big stored procedure.
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Commit transaction inside loops
Hello, our users are complaining about blocking during a delete loop so I'm thinking...
Ask SSC