How SQL Server executes a Query
Beginning with today, I want to give you over the next few months a blog post series about the basics of performance tuning in SQL Server. Before we go...
2022-02-04 (first published: 2022-01-25)
1,630 reads
Tech Lunch News
Předminulou středu jsme opět poobědvali a zároveň si nasdíleli řadu novinek ze světa dat. Tak doufám, že příště dorazíte i vy! Můžete klidně i jen poslouchat, pokud vás novinky...
2022-01-25
53 reads
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
2022-01-25
312 reads
Identify When your SQL Database Was Last Used
Database servers are used for storing vast amounts of data. It is essential to know when any user last used the database. This blog will cov
2022-02-07 (first published: 2022-01-24)
1,728 reads
Discovering diagram of dependencies in Synapse Analytics and ADF pipelines
Documenting objects dependencies of ETL processes is a tough task. Regardless it is SSIS, ADF, pipelines in Azure Synapse or other systems. The reasons for understanding the current solution...
2022-01-24
13 reads
Discovering diagram of dependencies in Synapse Analytics and ADF pipelines
Documenting objects dependencies of ETL processes is a tough task. Regardless it is SSIS, ADF, pipelines in Azure Synapse or other systems. The reasons for understanding the current solution...
2022-01-24
124 reads
A Quick Data Backup
The other day I was driving in the Tesla and clicked and Spotify application and chose a playlist. In this case, it was the “This is Stevie Wonder” playlist,...
2022-01-24
28 reads
Which Columns Are Looked Up?
A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...
2022-02-07 (first published: 2022-01-24)
448 reads
Daily Coping 24 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-24
22 reads
Introducing ScriptDOM
I’ve been meaning to get a series of blog posts started on this topic. A twitter conversation from yesterday finally pushed me to it. Last year, I was tasked...
2022-02-04 (first published: 2022-01-24)
889 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers