Sites anglophones

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 …

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.

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.

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 …

What Mail Items Have Been Sent With Database Mail

Publié le 11 septembre 2017 sur

Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed …

Challenge Your Code Design

Publié le 11 septembre 2017 sur

How to structure your T-SQL objects and incorporate design principles.

SQL SERVER – Remove Duplicate Chars From String – Part 2

Publié le 11 septembre 2017 sur journey to sqlauthority

I have already made a post on SQL SERVER – UDF – Remove Duplicate Chars From String where I showed you a method of removing duplicate characters form alphanumeric string. The UDF uses WHILE LOOP to extract the numbers. Here is another metho …

Pages :