Sites anglophones


Database Lifecycle Management: Deployment and Release

Publié le 20 juin 2016 sur simple-talk.com
 

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamw …

[Video] Office Hours 2016/06/15 (With Transcriptions)

Publié le 19 juin 2016 sur brentozar.com
 

This week, Brent, Angie, and Tara talk through your questions about monitoring tools, transactional replication, configuration management, source control software suggestions and much more! Here’s the video on YouTube: You can register to attend …

What is a Master Database in SQL Server? – Interview Question of the Week #076

Publié le 19 juin 2016 sur journey to sqlauthority
 

The other day, I received an email from a user, who had dropped master database in their system. I told him directly that he should have not dropped master database as that is a very important system database. It is really strange that after so many ye …

SQL SERVER – Installation Error – The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.

Publié le 18 juin 2016 sur journey to sqlauthority
 

The world of working with errors always gets the better of me. It is a wonderful way to understand why SQL Server behaves in a certain way and most importantly, it helps me solve some of the problems people face on a day-to-day basis. As you might know …

Let’s Make a Match: Index Intersection

Publié le 17 juin 2016 sur brentozar.com
 

Most of the time, when you run a query, SQL Server prefers to use just one index on a table to do its dirty work. Let’s query the Users table in the StackOverflow database (I’m using the March 2016 version today), looking for people wi …

Setup Azure Data Lake Analytics federated U-SQL queries to Azure SQL Database

Publié le 17 juin 2016 sur sqlblog.com
 

One of the major value propositions of U-SQL is that it allows to query data where it lives. For external systems, such as Microsoft Azure SQL Database, this is achieved with federated queries against data sources.     In order to query these …

What SQL Statements Are Currently Using The Transaction Logs?

Publié le 17 juin 2016 sur sqlservercentral.com
 

This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk ed …

How to version a SQL Server Master Data Services model

Publié le 17 juin 2016 sur sqlservercentral.com
 

In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as …

SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters

Publié le 17 juin 2016 sur journey to sqlauthority
 

Few days back I wrote blog about SQL Server 2016 Developer Edition free download. If you didn’t get a chance to have a look, here is the link. Download SQL SERVER 2016 Developer Version for FREE. Let us learn about how to install Sample Data …

SQL Server Master Data Services 2016 released!

Publié le 17 juin 2016 sur sqlblog.com
 

SQL Server 2016 was released recently. With that, all the new capabilities in Master Data Services are generally available. The details regarding the new capabilities are available on What’s New in Master Data Services (MDS) . To download SQL Server 20 …

Free Introducing Power BI eBook and new DAX recorded video course #powerbi #dax

Publié le 16 juin 2016 sur sqlblog.com
 

Microsoft Press released a free eBook you can already download, Introducing Microsoft Power BI, which I and Alberto Ferrari wrote in the last few months. Please note it is a very introductive book, don’t expect an inside-out. As we wrote in …

Questions You Should Ask About the Databases You Manage

Publié le 16 juin 2016 sur brentozar.com
 

First, what data do we have? Do we store any personally identifiable data? Does any of that data include children? Do customers believe that this data will never be seen publicly? Do customers believe that this data will never be seen by your empl …

Databases in Azure… Where to begin? Create a Database and log in!

Publié le 16 juin 2016 sur sqlservercentral.com
 

Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by- …

SQL SERVER – Database Mail Breaks with TLS 1.0 Disabled Discovery – Notes from the Field #128

Publié le 16 juin 2016 sur journey to sqlauthority
 

[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error related to Database Mail. Ryan is one guy who spends more time with real world issues with SQL Server th …

SSIS 2016 Administration: Create the SSIS Catalog

Publié le 15 juin 2016 sur sqlblog.com
 

Creating an instance of the SSIS 2016 Catalog is identical to creating an SSIS Catalog in SQL Server 2012 or SQL Server 2014. Follow these steps to create an instance of the SSIS Catalog on SQL Server 2016. Open SQL Server Management Studio (SSMS) and …


Pages :