Latest Blog Posts
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include the latest in SQL Server and other things in technology that I think are important or interesting…and maybe you will too!
So if you’d like to subscribe to… Read more
There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see… Read more
When I want to upgrade hardware, I usually turn to Glenn Berry for advice. He’s the person I know that really watches, examines, and evaluates computer hardware. He gives good advice and upgrades often, so he actually uses the latest hardware.
One of the upsides of his hobby is that… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
How can I tell if I have a Database Master Key in a database? It’s actually easy. I query the sys.symmetric_keys DMV for data. If I get… Read more
I was trying to get SQL Clone working recently and had an issue with the Agent. If you haven’t looked at SQL Clone, it’s a really cool product from Redgate that’s in beta right now. It will help you build and provision those large dev, test, customer service, etc. environments… Read more
This course targets IT professionals that design and… Read more
Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL
Join Rob Sewell and Chrissey LeMaire at SQL Sat Vienna on the 20th of Jan for a pre-con on PowerShell and SQL Server
Table of Contents
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like to see, but certainly include me in the list. I’ve got a few new ones, and a few that have been popular at other conferences. I am hoping to return… Read more
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a side by side upgrade and the only server principals used by the application were SQL Server authenticated logins. I tried over and over again but kept getting the same error. Read more
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