Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database
In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.
Rolling Back Migrations
The ways that one rolls back deployed database changes gets more complex with the migration development philosophy.
Generate HTML Formatted Email of SQL Server Database Consistency Check Errors
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
Posting SQL Server notifications to Slack
Learn how you can post notifications from SQL Server directly to a Slack channel.
Scheduling SQL Server Tasks on Linux
In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.
Generate QR Code® barcodes in an SSRS report with the QRCoder library
QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.
Generate two-dimensional QR Code® bar codes in an SSRS report
QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.
Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT BCA KCP Radio Dalam Telp:08218154393
Jl. Radio Dalam Raya No.5 B-C, RT.9/RW.13, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta...
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Alamat kantor BCA KCP Bantul Telp (0817)-866887
Wa:0817-866-887 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers