Sites anglophones


Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2

Publié le 27 août 2018 sur sqlservercentral.com
 

In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.

Documenting your Database with SQL Change Automation

Publié le 27 août 2018 sur sqlservercentral.com
 

Generating database documentation can be time consuming. Rather than abandoning it as a routine part of the process, try generating it separately, as a parallel process to the build, using the same tools. Phil Factor explains how. How to fix SQL Server …

SQL SERVER – How to DROP or DELETE Suspect Database?

Publié le 27 août 2018 sur journey to sqlauthority
 

One of my clients contacted me when there was business down situation. They had one of their production databases in suspect state and unable to drop it also. In this blog, we would learn about how to drop a suspect database. When they contacted me, I …

SQLintersection Fall 2018 (no clash with PASS this year!)

Publié le 26 août 2018 sur sqlskills.com - paul randall
 

As we head towards our 12th SQLintersection in December, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! For the first time in 4 years we have a new hotel contract that doesn’t have …

What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188

Publié le 26 août 2018 sur journey to sqlauthority
 

Question: What Part of the SQLDump Suggest Database Corruption? Answer: This was a very interesting to me as it was asked by my friend Kevin @Kevin3NF on the blog over here: SQL SERVER – Too Many SQLDump Files Consuming a Lot of Disk Space. …

SQL SERVER – FIX: CREATE FILE Encountered Operating System Error 5 (Access is Denied.)

Publié le 25 août 2018 sur journey to sqlauthority
 

One of my existing clients performed migration of disk in SQL Server failover cluster. After completing their planned activity, they found that SQL Server was not coming online in the cluster. In this blog, we would learn how to fix error CREATE FILE e …

DBAs Need a Jump Box or Jump Server.

Publié le 24 août 2018 sur brentozar.com
 

Every now and then, you’re going to need to run a query that takes a long time. You’re going to want to make sure that it succeeds and that you can see the full output – even if your workstation disconnects – or maybe you want t …

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

Publié le 24 août 2018 sur sqlservercentral.com
 

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps.

Trust, or Verify – How FKs Can (or Cannot) Help Performance

Publié le 24 août 2018 sur sqlservercentral.com
 

Learn how trusted foreign keys (FK) can help or hurt performance.

SQL SERVER – Upgrade Blocked: The Specified Edition Upgrade is Not Supported

Publié le 24 août 2018 sur journey to sqlauthority
 

As SQL 2008 R2 is out of support, my client was trying to upgrade to SQL Server 2012. In this blog, we would learn more about error message – Upgrade Blocked: The specified edition upgrade is not supported. Hi Pinal, We are into a situation and n …

Tall Tales From Table Variables

Publié le 23 août 2018 sur brentozar.com
 

Secret Squirrel When you modify a table with multiple indexes, SQL Server may choose either a narrow plan, if it doesn’t think all that many rows are going to change, or a wide plan if it thinks many will. In narrow plans, the work SQL Server has …

Spoofing Realistic Credit Card Data for your Test Systems using Data Masker

Publié le 23 août 2018 sur sqlservercentral.com
 

Data protection and privacy regulations, ranging from GDPR to HIPPAA to PCI, among many others, put strict compliance requirements on the storage and use of personal and sensitive data, in any of your systems. There is no distinction between developmen …

Count the Number of Weekend Days between Two Dates

Publié le 23 août 2018 sur sqlservercentral.com
 

Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates

Azure DevOps: Show Me the JSON!

Publié le 23 août 2018 sur sqlservercentral.com
 

Creating resources in Azure, while not difficult, can be time consuming if you use the manual steps. One way to automate the process is by using JSON templates to save time and enforce standards. In this article, Brian Flynn describes how to create JSO …

SQL SERVER – FIX: Backup to URL Error: Operating System Error 50(The Request is Not Supported.)

Publié le 23 août 2018 sur journey to sqlauthority
 

It is always fun to work with “Backup to URL” feature of SQL Server. The error messages which are raised are from Azure storage side and an SQLDBA won’t be able to understand the meaning. While I was working with my VM to learn someth …


Pages :