Sites anglophones


Read, Enrich and Transform Data with AWS Glue Service

Publié le 14 mars 2019 sur sqlblog.com
 

More and more companies are aiming to move away from managing their own servers and moving towards a cloud platform. Going serverless offers a lot of benefits like lower administrative overhead and server costs. In the serverless architecture, develope …

Building Better Stored Procedures

Publié le 14 mars 2019 sur sqlservercentral.com
 

In a followup, this article includes discussion of more advanced features of using stored procedures.

SQL Monitor 9 – Proactively Monitor Large SQL Server Estates

Publié le 14 mars 2019 sur journey to sqlauthority
 

Let me tell you about a real-world scenario which I often see at organizations I work with. In the perfect world, as organizations grow, their team should grow too. But often that isn’t the reality. The way it works out in most cases is, when org …

Converting a History Table into a System-Versioned Temporal Table

Publié le 13 mars 2019 sur simple-talk.com
 

SQL Server has had many different methods to track changes to data. There has been old-fashioned trigger-based logging, Change Data Capture, and Change Tracking. All of these features allow you to see how data has changed with varying degrees of how fa …

Poll: what conference schedule would you prefer?

Publié le 13 mars 2019 sur brentozar.com
 

There’s a vibrant discussion going on amongst conference attendees and organizers, and you can help. Take this 2-question poll about your preferred session schedule. This week’s sponsor: SQLGrease gets you to the root of your performance issues q …

SQL Server Referential Integrity Across Databases Using Triggers

Publié le 13 mars 2019 sur sqlservercentral.com
 

In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.

Using Client Tools – Level 4 of the Stairway to SQL Server on Linux

Publié le 13 mars 2019 sur sqlservercentral.com
 

In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.

Changing Trends & Technology – Challenging DBAs

Publié le 13 mars 2019 sur journey to sqlauthority
 

The biggest challenge as any technologies is that while you are getting super specialist at what you do, the world around you move so much ahead that when you look outside your windows you feel that you are expert at the technology which is actually hi …

Why You Need SQL Server Upgrade Knowledge

Publié le 12 mars 2019 sur sqlskills.com - glen berry
 

Introduction Both SQL Server 2008 and SQL Server 2008 R2 are falling out of extended support from Microsoft on July 9, 2019. SQL Server 2012 already fell out of mainstream support on July 11, 2017. Finally, SQL Server 2014 is also falling out of mainst …

Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

Publié le 12 mars 2019 sur simple-talk.com
 

“There are only two hard things in Computer Science: cache invalidation and naming things”Phil Karlton I’m terrible at naming things. I recently wrote some quick code to reproduce a design problem and demonstrate several options for s …

Pop quiz: what do these things cost?

Publié le 12 mars 2019 sur brentozar.com
 

It’s been a few years since we’ve stopped in for a sanity check. Quick: without searching the web for prices, put these items in order. Do it on a scratch paper, guessing how much you think each one costs, then arrange ’em. SQL Server …

Using Azure Resource Manager Templates To Provision Azure SQL Databases

Publié le 12 mars 2019 sur sqlservercentral.com
 

Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.

Isolation Levels in SQL Server

Publié le 12 mars 2019 sur sqlservercentral.com
 

Details discussion on the different isolation levels available in SQL Server

A Re-Introduction to HIPAA and SOX

Publié le 12 mars 2019 sur sqlservercentral.com
 

SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulation …

Business Secrets in SQL Server Performance Tuning Practical Workshop for EVERYONE

Publié le 12 mars 2019 sur journey to sqlauthority
 

Lots of people often ask me – What Will Attendee Learn in SQL Server Performance Tuning Practical Workshop for EVERYONE scheduled on April 23rd, 2019? The answer is pretty straight forward – my business secrets. What Motivates Me to Share M …


Pages :