Additional Articles

All authors

External Article

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.

2017-08-30

2,895 reads

External Article

Fighting Evil in Your Code: Comments on Comments

One of the most glib generalisations you can make about development work is to say that code should be liberally commented, or conversely that it should never be commented. As always, the truth is more complicated. There are many different types of comment and some types are best treated firmly with the delete key, where others are to be cherished and maintained assiduously. Even though it is hard to find two developers who agree on the topic of commenting, Michael Sorens warily sketches out the issues and the battleground.

2017-08-29

3,670 reads

Technical Article

Implementing Azure SQL Data Sync in the Azure Portal

Azure SQL Data Sync, which has been lingering in the Preview mode since its introduction seven years ago, no longer requires the use of the Azure classic portal; you can finally access it by using the current Azure portal. Marcin Policht steps you through the process of implementing Azure SQL Data Sync using this interface.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-08-28

2,868 reads

External Article

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.

2017-08-25

5,735 reads

External Article

Is It Time To Stop Using IsNumeric()?

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.

2017-08-21

4,500 reads

External Article

Database Code Analysis

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.

2017-08-18

3,546 reads

Technical Article

How to Read a Transaction Log Backup

The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2017-08-17

4,324 reads

External Article

Monitoring Azure Cloud and Hybrid Environments

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.

2017-08-16

3,995 reads

All authors

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

Alamat BCA KCP Pondok Bambu Tlp:0821-8200-233

By layanan_Bca88

Telp/WA 62 821-8200-233 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blk A/5-6, RT.2/RW.2, Wil,...

Alamat BCA KCP Klender Telp:0821-8200-203

By m4rt1n4

Telp/WA 62 821-8200-203 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren...

Alamat BCA KCP Pulogadung Trade Centre Tlp:08218200174

By R4nt4u

Telp/WA 62 8218200174 Kw. Industri Pulogadung, Jl. Raya Bekasi Km. 21, Ruko No.A2/18-19, RW.3,...

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers