Archives: July 2016
Power BI: If you have a Cloud of Words, let them Fly!
1 comments, 2,499 reads
Posted in Data Adventures on 31 July 2016
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I can’t begin to tell you how excited I am to be able to speak at this conference! I look forward to seeing you there!
Here’s the information on the… Read more
0 comments, 619 reads
Posted in Anthony Nocentino's Blog on 31 July 2016
The ROI of SQLSaturday for PASS & Decreased Event Funding
Returning to the post about Making SQSaturday Sustainable (see also a follow post about addressing concerns) it mentioned two topics that I wanted to look at more; the ROI for PASS and the decrease in funding to events.
For the past few years the standard has been for PASS… Read more
0 comments, 1,446 reads
Posted in SQLAndy on 30 July 2016
The End of the BAC–Why?
In a post titled The Future of the BA Community PASS announced that there would be no Business Analytics conference in 2017 and that the new strategy would be multi pronged, focused on local groups and events. I’ve never been a fan of the concept of the BAC so it… Read more
0 comments, 798 reads
Posted in SQLAndy on 30 July 2016
Reasons For Backup Failure In SQL Server and their Prevention
Overview:
The entire idea behind a backup, is to protect any organization from the data loss and corruption. However, the question arises what happen if user will loose the backup. Many times we still hear about businesses breaking down due to data loss. In this article we will discuss the… Read more
0 comments, 4,249 reads
Database Sessions at VMworld 2016
This year’s involvement in VMware‘s VMworld conference is up on the content catalog! I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US on August 27th. If your SQL Servers are running in a VMware environment, this course is… Read more
0 comments, 838 reads
Posted in Technobabble by Klee from @kleegeek on 29 July 2016
Why I like SQL Sentry Plan Explorer
0 comments, 604 reads
Posted in All About SQL on 29 July 2016
Columnstore Indexes – part 86 (“New Trace Flags in SQL Server 2016”)
Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/
With the release of SQL Server 2016, a great number of new functionalities with specific internal structures and own behaviours were created (Columnstore Indexes – part 60 (“3 More Batch Mode Improvements in SQL Server… Read more
6 comments, 929 reads
Posted in Niko's blog on 29 July 2016
Off-Topic: Phone number spoofing. Why is this still a thing?
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial a number and get a second dial tone; this way when dialing long distance the charges would be billed back to the company and not the employee.
I recall… Read more
2 comments, 866 reads
Posted in Confessions of a Microsoft Addict on 29 July 2016
Quick Scalar Tables–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
This actually comes from Itzik Ben-Gan, by way of Kevin Feasel. Kevin’s post is about CROSS APPLY, which is something I need to play with more… Read more
0 comments, 901 reads
Posted in The Voice of the DBA on 28 July 2016
Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a DAX formula. She had a Power BI dashboard in which she needed a very particular interaction to occur. She had slicers for geographic attributes such as Region and… Read more
0 comments, 761 reads
Posted in Data Savvy on 28 July 2016
Webinar – What’s new in SSIS 2016
I’ll be giving a webinar on the new features of Integration Services 2016.
When? August 11, 2016
Where? On the MSSQLTips.com website. You can register here.
Abstract:
SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this webcast, we will take a look at which…
0 comments, 787 reads
Posted in Koen Verbeeck on 28 July 2016
600 Miles, Limits, Fears, and Possibilities for SQLSaturday
Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule (has since been updated, still keeps the radius) to keep events from being held too close together and another that reduces the funding from PASS for most events. I appreciate the stated goals, find… Read more
0 comments, 1,307 reads
Posted in SQLAndy on 28 July 2016
T-SQL Tuesday #081: Sharpen Something
Sharpen Something
It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday 51. I recapped that event here with the original invite here. I can’t believe it has been that long since I last hosted. It only seems like yesterday. Read more
10 comments, 890 reads
Posted in SQL RNNR on 27 July 2016
Playing with TDE
4 comments, 500 reads
Posted in All About SQL on 27 July 2016
I wrote a SQL Server auditing whitepaper!
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server (database engine). You can grab it for free here (registration required):
Whitepaper: Top 5 Items to Audit in SQL Server
None of this is earth shattering. The whitepaper contains the… Read more
0 comments, 933 reads
Posted in Databases – Infrastructure – Security on 27 July 2016
When was this database restored?
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years as a DBA I can count the number of database restores for a disaster on my fingers? (Which is good because taking off your… Read more
5 comments, 825 reads
Posted in SQLStudies on 27 July 2016
An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible.
Anyway, one of the particular updates that caught… Read more
0 comments, 2,328 reads
Posted in Koen Verbeeck on 27 July 2016
Bug fixes in SQL Server
SQL Server 2016 CU1 has been released and one thing I noticed was: –
FIX: Canceling a backup task crashes SQL Server 2014 or 2016
That’s pretty nasty, when I originally clicked on the link I was expecting to see detailed a pretty precise set of circumstances in which that… Read more
1 comments, 766 reads
Posted in The DBA Who Came In From The Cold on 27 July 2016
Day1 - Assertiveness Skills: Communicating with Authority and Impact
For the rest of this week I…
0 comments, 952 reads
Posted in The SQL DBA in the UK on 27 July 2016