Sites anglophones


SQL Server 2017 CU2 Is Available

Publié le 29 novembre 2017 sur sqlskills.com - glen berry
 

On November 28, 2017, Microsoft released SQL Server 2017 CU2, which is build 14.0.3008.27.  I count 33 hotfixes in this CU. What is interesting is that there is a new column in the fix list called Platform, which will have a value of All, Linux, o …

So You Want a Cheap Disaster Plan

Publié le 29 novembre 2017 sur brentozar.com
 

There’s a lot that goes into a Disaster Recovery plan. One of them is offsite backups. There are some businesses that don’t have backups going offsite, let alone a Disaster Recovery plan. This conversation has taken place more than I though …

PASS SQL Saturday #687 Slovenia 2017 Last Call

Publié le 29 novembre 2017 sur sqlblog.com
 

If you want to join the event and you are not registered yet, this is the time to register. We are nearly full, opening the wait list soon. You can find the link to the registration at the end of this post. If you are already registered, one last appea …

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

Publié le 29 novembre 2017 sur sqlservercentral.com
 

This quick tip shows how to connect to Azure SQL Database instances from SQL Compare, using its built-in Active Directory authentication mode, giving you an easier and more secure way to, for example, deploy schema changes from version control to an Az …

Stairway to DAX and Power BI – Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Publié le 29 novembre 2017 sur sqlservercentral.com
 

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on …

New Partnership Brings SAP HANA Enterprise Cloud to Azure

Publié le 29 novembre 2017 sur sqlmag.com
 

SAP HANA Enterprise Cloud is now available on Microsoft Azure as part of a partnership announced today.

SQL SERVER – RDP Error to Azure Virtual Machines – The remote computer that you are trying to connect to requires Network Level Authentication (NLA)

Publié le 29 novembre 2017 sur journey to sqlauthority
 

I have some Azure Virtual machines which have AlwaysOn deployed for my quick testing purposes. Most of the time I keep them turned off by whenever there is a demo, I turn them on. In this blog post we will learn about RDP Error and how to fix it. In my …

WeWork Buys Meetup to Bring People Together Outside of Work

Publié le 29 novembre 2017 sur sqlmag.com
 

WeWork has been on an acquisition spree this year, buying smaller startups including Singapore-based co-working company Spacemob, computer coding academy The Flatiron School and investing in fast-growing women’s-only social club The Wing.

Webinar 2.6 – Fragmentation

Publié le 29 novembre 2017 sur sqlblog.com
 

Slides and scripts are now up from today’s webinar. https://www.dbbest.com/blog/webinar-2-6-followup-episode-9-fragmentation/ Thanks to all who attended!…(read more)

Excel Made Everyone an Analyst But Needs to Keep Up

Publié le 28 novembre 2017 sur sqlmag.com
 

Microsoft has enjoyed a de facto monopoly on spreadsheets and other office tools for more than two decades. But that kind of success breeds complacency.

VMware and AWS Say Move Your DR Data Center to the Cloud

Publié le 28 novembre 2017 sur sqlmag.com
 

The two partners are fleshing out their enterprise hybrid cloud story.

Good Reasons to Rebuild or Reorganize Indexes

Publié le 28 novembre 2017 sur brentozar.com
 

No, not that It’s not the F word. Not like this embarrassing page that was somehow updated in 2017, which still tells you to reorg at 5% and rebuild at 30% fragmentation, like your data is still on a drive that looks like a record player and migh …

What to Do When You Get a “Cache is Out of Date” Error Message

Publié le 28 novembre 2017 sur sqlservercentral.com
 

Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step …

What’s your opinion on database DevOps?

Publié le 28 novembre 2017 sur sqlservercentral.com
 

Gartner predicts that the transition to agile and DevOps will be as disruptive to IT as lean was to manufacturing during the 1980s. What about you? Are you implementing a DevOps way of working? Do the same approaches apply to the database? Take part in …

Database Cloning Tools in Lower Environments

Publié le 28 novembre 2017 sur sqlservercentral.com
 

With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.


Pages :