Sites anglophones

sp_whoisactive: The Big Fixes!

Publié le 18 octobre 2016 sur

Four and a half years have flown by since I released sp_whoisactive version 11.11 . It’s been a pretty solid and stable release, but a few bug reports and requests have trickled in. I’ve been thinking about sp_whoisactive v.Next — a version that will …

Searching Strings in SQL Server is Expensive

Publié le 18 octobre 2016 sur

In the classic spirit of my How to Think Like the Engine class, let’s go take a look at the StackOverflow.Users table and find all the users named Brent. There’s a DisplayName field, and I’m going to be querying that a lot in this blo …

Automatically upload SQL Server Database Backups to Azure with Integration Services

Publié le 18 octobre 2016 sur

Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk e …

Time Traveling with Temporal Tables on SQL Server 2016

Publié le 18 octobre 2016 sur

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse upda …

Developing Redgate’s SQL Toolbelt

Publié le 18 octobre 2016 sur

Take a look behind the scenes to learn more about Redgate’s development challenges, what role the SQL Toolbelt plays, and which releases are coming up.

Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries

Publié le 18 octobre 2016 sur journey to sqlauthority

I hope it is no secret that testing of written code is as important as writing the code itself, and sometimes even more important. Writing unit test for C#/Java/…code coverage is the responsibility of each software developer. However, there is n …

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

Publié le 18 octobre 2016 sur

Welcome back! I have found some great articles to be read Hope you will have a lot of fun reading all of them.   Author Title Link Rob Farley Passwords – a secret you have no right to share Paul White The sorts that spi …

[Video] Office Hours 2016/10/12 (With Transcriptions)

Publié le 17 octobre 2016 sur

This week, Brent, Richie, and Erik discuss estimating compression savings, disabling triggers, suggestions to first-time Pass Summit attendees, tools for database version control, transitioning from SQL 2000 to 2016, troubleshooting failovers, and how …

How to Set Up SQL Server Database Mail in One Easy Script

Publié le 17 octobre 2016 sur

Database Mail in Microsoft SQL Server allows for messaging to occur between SQL Server and anyone with a valid email address. It can be daunting to set up through SQL Server Management Studio but by using the SQL Server Template in this article you’ll …

Using OVER() to Fix Bad Version Numbers

Publié le 17 octobre 2016 sur

See how the OVER() clause was used in a live system to fix overlapping field version numbers.

SQL SERVER – Database going to Recovery Pending Automatically and Coming Back

Publié le 17 octobre 2016 sur journey to sqlauthority

I love connecting community via various channels. One of my clients explained an interesting issue to me. He explained that he has a production database which is going to Recovery Pending state by itself and without any user intervention, it’s co …

Keep more history for your Agent jobs

Publié le 16 octobre 2016 sur

SQL Server Agent is in my opinion way too restrictive when it removes old job history information. This information is store in the dbo.sysjobhistory table in the msdb database. Unfortunately, Agent will by default only keep 1000 rows in this table. I …

When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093

Publié le 16 octobre 2016 sur journey to sqlauthority

If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password. Error 1069: The service did not start due to a logon failure. Question: When was Domain Account Password Changed in SQL S …

SQL Down Under Show 69: with guest Data Platform MVP Glenn Berry

Publié le 16 octobre 2016 sur

Hi Folks, The next SQL Down Under show is now online. In it, Glenn Berry discusses hardware and hardware-related performance issues for SQL Server. You’ll find the show here: Enjoy !   More on Glenn: Glen …

SQL SERVER – Error: 26014, Severity: 16. Unable to Load User Specified Certificate

Publié le 15 octobre 2016 sur journey to sqlauthority

Recently I was consulting a customer and they had plans to change certificate used by SQL Server. After making changes to certificate, we found that we were not able to start the SQL Server Service. Let us learn about how to fix error 26014 about unabl …

Pages :