Sites anglophones

Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate

Publié le 14 septembre 2017 sur

In this webinar, Microsoft MVP Steve Jones and Redgate’s Arneh Eskandari will show you how Redgate’s Database DevOps solution can work to improve your database development and deployment processes. You’ll see a demo of the following Redgate …

Automate MSBI deployments Using PowerShell

Publié le 14 septembre 2017 sur

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edito …

SQL SERVER – How to Reach Out to Cloud – Cloud Computing with PartitionDB

Publié le 14 septembre 2017 sur journey to sqlauthority

Cloud Computing is not new anymore; everyone is talking about the cloud. Has everyone already touched the sky?   Apparently not. There are many organizations around that hesitate to make the move, or cannot because of compliance issue or other lim …

Questions About RDS SQL Server You Were Too Shy to Ask

Publié le 13 septembre 2017 sur

What is RDS SQL Server? What versions of SQL Server are supported on RDS? How do I copy an existing SQL Server database into RDS? Do I have SA rights in RDS SQL Server? If lose the password of the master user what would I need to do to get access back? …

Indexing for Windowing Functions: WHERE vs. OVER

Publié le 13 septembre 2017 sur

Life Is Messy Demo queries have this nasty habit of being clean. Even using a pit of despair like Adventure Works or World Wide Importers, it’s easy to craft demo queries that fit the scenario you need to make yourself look like a genius. Stack O …

Protecting SQL Server from Ransomware

Publié le 13 septembre 2017 sur

The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware.

Moving Dynamic Data Masked Data to New Locations

Publié le 13 septembre 2017 sur

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.

SQL SERVER – Convert Decimal to Time Format in String

Publié le 13 septembre 2017 sur journey to sqlauthority

A very strange question I received the other day in an email about how to convert decimal to time format string. Here is the email I received: “Pinal, I have a very strange issue with string formatting. I have a string like 5.07 which I need to c …

Consuming hierarchical JSON documents in SQL Server using OpenJSON

Publié le 12 septembre 2017 sur

Articles by Phil Factor about JSON and SQL Server: Consuming JSON Strings in SQL Server (Nov 2012) SQL Server JSON to Table and Table to JSON (March 2013) Producing JSON Documents From SQL Server Queries via TSQL (May 2014) Consuming hierarchical JSON …

The easiest way to start using variables in #dax

Publié le 12 septembre 2017 sur

I just published a new blog post on SQLBI.You can read it at this link: 

How Much Can One Row Change A Query Plan? Part 1

Publié le 12 septembre 2017 sur

Last week, Erik showed two queries that were aaaaalmost identical, with only one extra column – and the execution plans were dramatically different. Adding just one eensy column made all the difference in the world. Now, check out these two queri …

Guide available for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

Publié le 12 septembre 2017 sur

The EU Global Data Protection Regulation (GDPR) goes into effect on May 25, 2018 – and we know that many of you are searching for guidelines and recommendations for how to properly handle the data privacy and data protection requirements stipulated by …

Pattern Recognition via Principal Components Analysis

Publié le 12 septembre 2017 sur

We’ll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.

SQL SERVER – How to Create Linked Server to SQL Azure Database?

Publié le 12 septembre 2017 sur journey to sqlauthority

If you take the normal approach to create a linked server to SQL Azure Database, then you would end up in below error message. Here is the text of the error message Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) Refe …

Speaking at SQL Saturday in Spartanburg

Publié le 11 septembre 2017 sur

  I haven’t been to this area of South Carolina in many years but I always enjoyed my visits so I am looking forward to this trip as well. Although I have to admit I am not looking forward to the 6 hour drive each way : ).  There are a …

Pages :