Sites anglophones

Temporal Tables – Part 4 – Synchronizing changes across tables

Publié le 10 mai 2016 sur

So way back in June of last year, when I started this series on Temporal Tables: Part 1 – Simple Single Table Example , Part 2 – Changing history ; and even in Part 3 – Synchronizing Multiple Modifications ; I only referenced one table. In this e …

What you should read 🙂 during the upcoming !!! weekend – weekly SQL Server blogs review part 14

Publié le 10 mai 2016 sur

Today I have really something extraordinary. We have been waiting so long to have a comprehensive wait statistics and latches description. And now we have them! Paul Randal prepared and posted a great source of information. This is a must read! By the …

Looking at VIEWs, Close Up

Publié le 10 mai 2016 sur

Views in SQL can be difficult. It isn’t easy to judge when to use them, It isn’t always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.

The Enterprise DBA Mindset as a Practical Problem-solving Approach

Publié le 10 mai 2016 sur

In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a ‘managed’, consiste …

Understanding Big Data and NoSQL Databases

Publié le 10 mai 2016 sur

Sponsored by: Couchbase Thursday, June 30th at 12pm ET read more

The Recording for Biml Academy Lesson 0–SSIS Design Patterns is Live!

Publié le 9 mai 2016 sur

The recording for Biml Academy Lesson 0-SSIS Design Patterns is now live! Registration is required but I promise to only send you updates about the cool stuff we’re working on at Enterprise Data & Analytics and Andy Leonard Consulting which i …

Announcing the comprehensive SQL Server Wait Types and Latch Classes Library

Publié le 9 mai 2016 sur - paul randall

It’s finally ready! For the last two years, I’ve been working on-and-off on a new community resource. It was postponed during 2015 while I mentored 50+ people, but this year I’ve had a bunch of time to work on it. I present to the com …

Why monitoring SQL Server is more important than ever

Publié le 9 mai 2016 sur

Moving parts SQL Server keeps on growing. With every new edition, you get more features, feature enhancements, and uh, “feature enhancements”. As I’m writing this, SQL Server 2005 is less than a week away from support ending, and SQL …

RANDom traps for the unwary

Publié le 9 mai 2016 sur

The Books Online description of the RAND() function is only true from certain perspectives.

Big Data Architecture

Publié le 9 mai 2016 sur

The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. In this article, Lockwood Lyon addresses how to meet this need, as users demand greater …

PowerShell – Backup SQL Server System Databases

Publié le 9 mai 2016 sur journey to sqlauthority

I have been lately writing on powershell and didn’t know there are many more scenarios that can be enabled. I was traveling for a consulting assignment over the weekend for a customer location. Though this exercise was around performance tuning t …

Top Four Enterprise Infrastructure Mistakes

Publié le 8 mai 2016 sur

Every business runs different workloads and has different resource requirements. For many businesses, building out the optimal set of enterprise IT infrastructure components can be a trial-and-error process where things don’t always work out the …

[Video] Office Hours 2016 2016/05/04

Publié le 8 mai 2016 sur

This week, Richie, Erik, Angie, and Tara discuss deadlocks, replication, SQL Server 2016 features, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen o …

List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070

Publié le 8 mai 2016 sur journey to sqlauthority

There are few questions which never gets old. Today we are going to one such question. Every single time I go for expert panel in the interview and I end up seeing candidate failing to answer this question about the Stored Procedure modification date. …

Use AutoCorrect in Word to Prevent SQL Sever

Publié le 8 mai 2016 sur

Too often I see SQL Server misspelled as SQL Sever. You can easily prevent this by using AutoCorrect in Word. Start by clicking on File . Figure 1. Click on File in Word. Next, click on Options . Figure 2. Click on Options . On the Word Options dialog …

Pages :