The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news … Read more
The first week of November was a big week for Microsoft. They made many announcements at the Ignite conference about what’s new and what will be available in the near future. It was also the week of PASS Summit, the largest Microsoft Data Platform conference in the world. PASS Summit was a fantastic conference as … Read more
I can’t remember a time when I was not involved in side-projects, usually as a volunteer but also writing books or creating courses. New projects are like bright, shiny objects, and it’s easy to get involved in too many of them. Earlier this year, I found myself working on three books at the same time. … Read more
I never allowed my children play with modelling clay in my home when they were young, but changed my mind when grandchildren arrived. I have the perfect table, a discarded fast food restaurant booth, so that the mess stays in one spot. There is one sturdy box to hold all the cans of dough and … Read more
After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to develop their new tool, Azure Data Studio (formerly known as SQL Operations Studio), … Read more
The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the future. Chris walks in. Chris: Kathi, have you seen the … Read more
I’ve worked with Microsoft technologies for over 20 years and, during that time, earned a good income to support my family and have a comfortable life. Despite that, Microsoft manages to break my heart again and again. Take the sad saga of the Windows Phone. I was working for Microsoft when the first Windows Phones … Read more
Back when I was working on a master’s degree, one of our professors told us a story about a colleague who learned how to navigate the Unix system. She was so thrilled about learning this new skill that, in her exuberance, she stumbled upon some hidden human resource files containing confidential information. Eventually, an administrator … Read more
Joe Celko explains why questions requiring yes or no answers are more complicated than you might realize in both spoken language and computing.… Read more
In my previous career many years ago, I worked at a hospital along with about ten other pharmacists. The department manager came up with one primary metric for evaluating pharmacists: the average time taken to fill each drug order. While this system did produce a metric, it was the wrong one. The worst pharmacist in … Read more
I was talking recently with a friend about features of SQL Server 2019 (still in CTP at the time of this writing). I thought that while Microsoft provides features that will benefit any size shop, the exciting new feature they are promoting is Big Data Clusters. This feature allows you to query data from many … Read more
Now that school is out for the summer, my grandson Thomas is spending quite a bit of time at our house. This year his parents decided that, at 12 years old, he was too old to go to a day-care/summer camp program. He will probably take over quite a bit of the yard work and … Read more
The process of putting together a team of technical people once was largely centered around getting a group of similarly minded people. How people worked was valued more than how well they could accomplish their job. Finding people who could work together smoothly was a big focus when picking new team members, and was a … Read more
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go. … Read more
We humans have been the most successful animals on earth. We’ve accomplished this by changing the environment to suit our needs instead of always adapting ourselves to fit the environment. We use tools, we invent, and we solve problems. Of course, many other species use crude tools, but none have done anything like inventing computers, … Read more
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!) DBAs … Read more
Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why should licensing an automation product be related to the number of users? … Read more
If you are a Star Trek fan, you’ve seen the future of medicine, or at least how the writers imagine it will be. Painless, needleless injections are given by hypospray devices, right through clothing with no chance of cross-contamination. The medical tricorder provides an accurate diagnosis in seconds. Broken bones, illnesses, and injuries are quickly … Read more
If you have worked with databases long enough, you probably have many frightening stories to tell about things that have gone awry on the job or problems that were difficult to solve. Accidently dropping a table or trying to fix an issue with the CIO standing right in your cube, repeatedly asking if you’ve fixed … Read more
“There are only two hard things in Computer Science: cache invalidation and naming things”Phil Karlton I’m terrible at naming things. I recently wrote some quick code to reproduce a design problem and demonstrate several options for solutions, and later realized that I’d named my objects dbo.Foo, dbo.FooFoo, and dbo.Wat. But I feel strongly about a … Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
