Sites anglophones

Apply AND instead of OR logic to multiple selection in a slicer #dax #powerpivot #powerbi

Publié le 17 novembre 2015 sur

I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customer …

Making Deployments Simpler with Re-runnable Scripts

Publié le 17 novembre 2015 sur

Make sure your SQL Server database release scripts to make life easier.

SQL SERVER – Looking Inside SQL Complete – Advantages of Intellisense Features

Publié le 17 novembre 2015 sur journey to sqlauthority

Recently SQL Complete add-in was updated, which I use when writing SQL queries in SSMS. In the product history I saw that a several features were added, such as code refactoring or automatic semicolon insertion. However, in this post I do not want to t …

Jodie Beay and the Production Database Drift

Publié le 17 novembre 2015 sur

You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you’re worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of …

The free #eBooks series #SQLServer and .NET Blog

Publié le 16 novembre 2015 sur

The series of free eBooks « The SQL Server and .NET Blog eBook Series » by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase Administrat …

What you should have read 🙂 during the weekend – weekly SQL Server blogs review part 7

Publié le 16 novembre 2015 sur

Hello! It is Monday so I am delivering you the new articles to read! Hope you will have a lot of fun reading all of them!     Author Title Link CSS SQL Server Engineers Are my statistics correct? Chris Webb Power BI …

November 2015–Learn SQL Server and Visual Studio

Publié le 16 novembre 2015 sur

A reader emailed to ask what I recommend for learning current software and database development. I responded with these links: VirtualBox Windows 2016 Server TP3 SQL Server 2016 CTP 3 Visual Studio 2015 I believe the software is all free, though it is …

Hash Joins on Nullable Columns

Publié le 16 novembre 2015 sur

Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.

SQL Server 2016 Stretch Database

Publié le 16 novembre 2015 sur

SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.

MySQL – Get Latest Identity Value by Inserts

Publié le 16 novembre 2015 sur journey to sqlauthority

In SQL Server, whenever you add data to a table that has an identity column, you can get the lastly generated identity value using @@identity or scope_identity(). Similarly, in MySQL you can make use of LAST_INSERT_ID () function Let us create the foll …

Doing a SQL Server Healthcheck via PowerShell

Publié le 16 novembre 2015 sur

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed …

SQL Server Data Tools (SSDT) and Database References

Publié le 16 novembre 2015 sur

SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexit …

Interview Question of the Week #045 – How to Do Case Sensitive Search?

Publié le 15 novembre 2015 sur journey to sqlauthority

One of my popular questions which helps me to understand lots of understanding of SQL by SQL developer. Question: How doing a case sensitive search in SQL Server? Answer: If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEAR …

SQL SERVER – Installation failed with error – Wait on the Database Engine recovery handle failed

Publié le 14 novembre 2015 sur journey to sqlauthority

You might have seen on Facebook that I have completed the new setup of my machines. Since I use VMs to do my tests. To have a domain, I made a VM as domain controller and another as a member server. Next step was to install SQL Server and by mistake, I …

Capture Execution Plan Warnings using Extended Events

Publié le 13 novembre 2015 sur

Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.

Pages :