Latest Blog Posts
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL Authentication. I had no idea but said I would find out. This is how and what I did.
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live talk today.
— Robert Chipperfield (@rmc47) December 15, 2016
When we decided to stream… Read more
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on linux.
The first thing you do when playing with a new technology is see how you can break it right? Always good fun
So I’m going to break a database… Read more
Most of the time users need to import their data into SQL Server for its proper management. Select from the variation of source as well as destination data source types, choose tables for copying or even for specifying own query for data extraction and store the work as SSIS package.… Read more
We have all made mistakes in our careers, I thought I’d share one of mine as a quick tip to others so that you don’t make the same one.
Everyone has their SQL Alerts setup right? If not, I have included the script below and here is the MSDN link… Read more
Here is my bug report:
https://connect.microsoft.com/SQLServer/feedback/details/3022019 and it is still in active.
It happen one of my production database, when I tried to remove the database… Read more
Today’s TAPtips is about Increased Productivity with the Pomodoro Technique. Have you tried the Pomodoro Technique? If so, what were your results?
Today’s TAPtips is on increased productivity with the Pomodoro Technique. I first learned of the Pomodoro Technique several years ago while reading Quora posting, and felt… Read more
In this module you will learn how to use the Sankey Bar Chart Power BI Custom Visual. The Sankey Bar Chart is used to show a flow of data between different stages of a process.
Module 33 – Sankey Bar Chart
- Power BI Custom Visual – Sankey Bar Chart
Data Definition Language queries don’t go through the optimizer, right? While normally, my short answer to this question in the past would have been, yes. However, with testing comes knowledge and I want to be sure about the statement.
I’m working with a team of people to completely rewrite the… Read more
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the sp_helpindex stored procedure is rather badly flawed. It doesn’t have the included columns from the index. This seems a bit strange to me since included columns first appeared in… Read more
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among the most likely to fail. At one time, Gartner reported that more than 50% of data warehouses would fail to make it to user acceptance. Because of the size of… Read more
Brent wants us to blog about our favorite Connect items because Microsoft is currently listening to its customers and actually closing items.… Read more
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Brent Ozar (b/t) and this months topic is SQL Server Bugs & Enhancement Requests.
My enhancement request for SQL… Read more
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think blogging is a great way to showcase your knowledge, and over time, this can become as important to your potential employers and clients as your resume or CV.
This… Read more
SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international speakers will gather to deliver sessions relating to SQL Server and all related services. It’s a fabulous agenda – take a look I am sure that it will be… Read more
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left me.
For most people, there’s a good break over the Xmas period but most IT workers that I know had to be on-call for some or most of the holiday… Read more
SQL Server 2016 SP1 was released in November 2016 only five months after the initial release.
There have been some significant changes and additions in this release. The most significant of which is that many features that once only existed in Enterprise edition, such as Always Encrypted,…