Sites anglophones


[Video] Office Hours 2018/9/19 (With Transcriptions)

Publié le 23 septembre 2018 sur brentozar.com
 

This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corruption, rebooting/restarting SQL server after applying cumulative updates, how many drive letter to use for a VM, d …

How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192

Publié le 23 septembre 2018 sur journey to sqlauthority
 

Question: How to Escape a Single Quote in SQL Server? Answer: Yesterday, I had an opportunity to visit a SQL User Group in Bangalore, India, and during the event, I had received a very simple question from a college student. As soon as he asked th …

Leaked: SQL Server 2019 Big Data Clusters Introduction Video

Publié le 22 septembre 2018 sur brentozar.com
 

Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQL Server 2019 Vision pic.twitter.com/zbjI28FYSu — WalkingCat (@h0x0d) September 21, 2018 What the video says Growing volumes of data create deep p …

SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time

Publié le 22 septembre 2018 sur journey to sqlauthority
 

I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. …

6 DBA Lessons I Wish Someone Would Have Taught Me Earlier

Publié le 21 septembre 2018 sur brentozar.com
 

I was talking to a DBA friend of mine, reminiscing about some of the hard lessons we learned early on in our career. The more we talked, the more we realized that there should probably be a one-page cheat-sheet that you’re required to read before …

Adding User Comments to Reports in SQL Server Reporting Services

Publié le 21 septembre 2018 sur sqlservercentral.com
 

In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.

Learning R in SQL Server

Publié le 21 septembre 2018 sur sqlservercentral.com
 

Learn about the new R Services in SQL Server 2016

SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts

Publié le 21 septembre 2018 sur journey to sqlauthority
 

Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to achieve this task. However, there …

Finding & Fixing Statistics Without Histograms

Publié le 20 septembre 2018 sur brentozar.com
 

Men Without Hats – now those guys were cool: Statistics Without Histograms – not so much. If you have a database that’s been passed along from one SQL Server to another, gradually upgraded over the years, or if you’ve had a tabl …

New VLF status value

Publié le 20 septembre 2018 sur sqlskills.com - paul randall
 

At least since I started working on the SQL Server team (just after 7.0 shipped) and since then there have only been two VLF status codes: 0 = the VLF is not active (i.e. it can be (re)activated and overwritten) (1 = not used and no-one seems to rememb …

Advanced Testing of Your PowerShell Code with Pester

Publié le 20 septembre 2018 sur sqlservercentral.com
 

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.

Identifying the right Service tier for Azure Database

Publié le 20 septembre 2018 sur sqlservercentral.com
 

Determining the number of DTUs which will help in deciding the service tier for Azure SQL.

Pseudonymizing a Database with Realistic Data for Development Work

Publié le 20 septembre 2018 sur sqlservercentral.com
 

In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact.

Encryption Key Management for Microsoft SQL Server 2008-2016

Publié le 20 septembre 2018 sur sqlmag.com
 

Organizations continue to experience damaging losses due to data breaches, including legal costs, costs to reimburse customer and employees, lost stakeholder value, and reduction of goodwill. In recognizing the importance of proper key management for

SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date

Publié le 20 septembre 2018 sur journey to sqlauthority
 

In my very old post SQL SERVER – Query to Find First and Last Day of Current Month – Date Function, I had explained how to find the first day and last day of the current date. The method I showed you in the old posted uses CONVERT function …


Pages :