SQL Server 2017 CU2 Is Available
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
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
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
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
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
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)
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
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
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
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
The two partners are fleshing out their enterprise hybrid cloud story.
Good Reasons to Rebuild or Reorganize Indexes
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
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?
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
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.