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)
887 reads
Data Thoughts – Microsoft Exams and Simulations
G’day, I’ve based my career around Microsoft products on the Data Platform. The first product that I seriously learnt was Microsoft SQL Server back around 2000. I was lucky...
2022-01-23
27 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers