Sites anglophones

Migrating Databases to Azure SQL Database

Publié le 28 novembre 2016 sur

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step- …

SQL in the City Streamed

Publié le 28 novembre 2016 sur

Register now for Redgate’s free virtual event offering a wealth of SQL Server sessions for you to live-stream on December 14 and 15.

How to Change an Analysis Services Instance to Tabular Mode

Publié le 28 novembre 2016 sur

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode

SQL SERVER – Playing with Backups and Compression

Publié le 28 novembre 2016 sur journey to sqlauthority

The era of innovation with SQL Server administration side of things keep happening, it is strange that a lot of us miss these capabilities getting added into the system. I have seen processes define the way how DBA’s work. In a lot of places, the …

Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)

Publié le 27 novembre 2016 sur

You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you …

SQL Server 2016 SP1 Bug with Graphical Execution Plans

Publié le 27 novembre 2016 sur

Early adopters: if you’re rolling on SQL Server 2016 SP1, you may have noticed that when you click on query plans in sp_BlitzCache or sp_WhoIsActive, they sometimes render as ugly XML rather than the beautiful graphical showplan. Here’s a 3 …

How to Downgrade Database from SQL Server 2014 to SQL Server 2012 – Interview Question of the Week #099

Publié le 27 novembre 2016 sur journey to sqlauthority

Question: How to downgrade from SQL Server 2014 to SQL Server 2012? Answer: Not possible. Do not give up reading this blog post there is one workaround. Workaround You can script your entire database with Data and then execute the script on your new da …

SQL SERVER – System Function @@IDLE to Find System Ideal Time

Publié le 26 novembre 2016 sur journey to sqlauthority

Just the other day I got an email with user asking how does the @@idle function work with SQL Server as when he runs them it gives him some number but the number is not easy to interpret. I totally agree with the observation. When I was new to SQL Serv …

SQL Down Under show 70–Aaron Bertrand–SQL Server 2016 SP1, SQL Server on Linux, SentryOne Plan Explorer

Publié le 26 novembre 2016 sur

Hi Folks, I got to record another podcast last week and it’s published now: The guest this time was Data Platform MVP Aaron Bertrand. We initially planned to mostly just discuss SentryOne Plan Explorer because …

SQL Server Management Studio and Usability

Publié le 26 novembre 2016 sur

SQL Server Management Studio has moved into the Visual Studio 2015 shell. In general, that’s a really good thing. There are many built-in benefits that come from using that shell. I’ve been showing people many of these. One that surprises m …

Source Control for SSMS

Publié le 25 novembre 2016 sur

  It would be awesome if we could use source control such as TFS directly in SSMS like we can in Visual Studio but at the moment we can’t for the reasons explained by Ken Van Hyning in this blog post .  However he also explains how we c …

Index Scans: Not Nearly As Bad As You Might Think

Publié le 25 novembre 2016 sur

Using our good old buddy the StackOverflow demo database, let’s look at the Users table. I want to get the first 10 users in the table ordered by Id, the primary clustered key, which is an identity field. Here’s the actual execution plan: h …

Top 5 things you MUST know about PowerPivot for Excel

Publié le 25 novembre 2016 sur

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.

What’s New in SQL Server Reporting Services 2016

Publié le 25 novembre 2016 sur

Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.

SQL SERVER – Stop Growing MSDB Database by Removing sysmail_mailitems History

Publié le 25 novembre 2016 sur journey to sqlauthority

Received an email “Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our sysmail_mailitems table. We are also facing performance issues.” I have been an independent consultant for a while an …

Pages :