Convert Local Datetime to UTC (pre-SQL Server 2016)
Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some very useful T-SQL functions/clauses who didn’t exist in 2012,...
2022-02-17
23 reads
Blog Posts
Daily Coping 17 Feb 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-02-17
31 reads
SQL Saturday Colorado Springs 2022
In just over a month, SQL Saturday comes back to Colorado Springs. On Mar 19, SQL Saturday Colorado Springs 2022 is taking place at the local library. This is...
2022-02-17
89 reads
Checking accessibility in your day-to-day work
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create...
2022-02-16
89 reads
Daily Coping 16 Feb 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-02-16
35 reads
Data Thoughts – Renewing Microsoft Certifications
G’Day, I recently renewed one of my Azure Certifications, extending it by another year from the original expiry data. You can extend any certification that is about to expire...
2022-02-16 (first published: 2022-02-05)
436 reads
Key (Lookup) in SQL Server Key Lookup performance
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.
2022-02-16
253 reads
SQL Server – Backing up the Tail of the Log
When a database gets corrupted or failure occurs, before restoring the database from the backups you've created, it is recommended to create a tail-log backup of the records that...
2022-02-16 (first published: 2022-02-07)
930 reads
Azure DB for MySQL – Replication
No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons. If you have been following me in...
2022-02-15
29 reads
Daily Coping 15 Feb 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-02-15
19 reads
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCP Surabaya Telpon/wa:0821°8168°291
BCA KCP Surabaya Telpon/wa:0821°8168°291.Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan,...
BCA KCP Kampung Baru Telpon/wa:0821°8168°291
Kampung Baru Telpon/wa:0821°8168°291.Jl. Brigjend Katamso No.680, Kp. Baru, Kec. Medan Maimun, Kota Medan, Sumatera...
BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291
BCA KCP Plaza Medan Fair Telpon/wa:0821°8168°291.Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G,...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers