Conditional Formatting with SSRS
An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.
Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
Is Azure SQL Database a Good Choice for your Database Applications?
In this article, we cover things you should know about Azure SQL Database and why this may be a good choice for your database applications.
Why bother automating?
Bob Pusateri, Database Engineering Lead at Salesforce, joined our recent Summit to discuss how automation can enable digital transformation. Listen in full.
AI Medical Record Scanning
Artificial Intelligence can help humans, both in diagnosis, but also in teaching medical professionals.
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
Stairway to SQL Server Virtualization Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine
In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.
Introducing the MySQL UPDATE statement
In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML) statements in MySQL. In this article, I focus on the UPDATE statement, another valuable DML statement in MySQL.
Using SQL Backup in Development Work
For a development team, SQL Backup provides a simple way to restore development or test databases, if required, while minimizing the tedium of the task of taking, managing, and restoring the backups. We can generate the required backup commands in the GUI and then use them to construct a SQL script that backs up all the required databases. We can even use the backup commands in a beforeMigrate SQL callback, in Flyway, to make sure the current version is safely backed up before we run migration.
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Bank BCA KCU MENARA BCA Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat Bank BCA KCU THAMRIN Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec....
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers