It was always important to me to keep up with the latest versions of SQL Server, but especially so when I was a database administrator or consultant. I wasn’t always able to work with the new versions right away in production, but at least I had an idea about features, capabilities, and benefits. Fifteen years … Read more
I recently presented a session about DevOps for DBAs, explaining what it is and why DBAs should care. One of the comments I received was “I thought I knew what DevOps was. Thanks to your session, now I know better.” Here’s one definition of DevOps: The union of people, process, and products to enable continuous … Read more
Many of you know that Redgate purchased some of the assets of PASS, namely session recordings, domain names, and trademarks. Shortly after that purchase, we began talking about what it would take to put on an event to revive PASS Summit. The first step was to survey to find out what people liked and wanted … Read more
Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn’t have deadlines, we’d stagnate. ― Walt Disney I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild … Read more
I began attending PASS Summit in 2003. I had no idea that it would change the course of my career and, well, life. Becoming part of the community I found through PASS inspired me to take my career to the next level by presenting and writing. It also led to some wonderful friendships and lots … Read more
Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query not included in a stored procedure and not parameterized or prepared. Depending on the server settings, SQL Server can parameterize some statements initially written as ad hoc queries. Ad hoc doesn’t mean dynamic. Here’s a … Read more
Redgate released the 2021 State of Database DevOps Report in February, and I wrote a short article talking about the key insights from the report. More recently, I decided to take a deeper look at the data, especially how folks from different roles answered the survey questions. To simplify my analysis, I grouped respondents into … Read more
When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my job. I remember that I was able to buy a tool to compress database backups before that functionality was built into SQL Server. I also had a handful of licenses for … Read more
I’ve noticed that some television shows have been incorporating the Covid-19 pandemic into their recent episodes. (There are some spoilers here, so read with caution!) A medical series, “The Good Doctor,” featured it in two episodes and then, magically, the pandemic was over. The popular series “This is Us” is trying to set a good … Read more
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored procedure, inline table valued function (tvf), or extended stored procedure. They can also be … Read more
Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you shouldn’t feel like an imposter when you get out of your comfort zone. It talked about how incredibly successful people didn’t know how to do what they eventually accomplished back when they started. For example, … Read more
This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each year, the number of respondents increases, reaching 3,200 submissions this year. An interesting new topic to consider this year is how the Covid-19 pandemic affected DevOps practices. Here are the some of the key insights found in the … Read more
If you are lucky enough to enjoy the work you do, it could be because you are frequently “in the zone.” The zone is a state of complete concentration, also called “flow,” where time seems to stand still, and performance is at its peak. Before I heard these terms, I often experienced deep concentration while … Read more
Why is it such a cliché to complain about our parents? You hear it from friends or in films all the time…”damn, I have to go to my folks for dinner. It’s gonna be rough.” It’s a tale as old as time. As our parents age (and retire), they inevitably participate in the world less. They interact with the world far … Read more
SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.… Read more
Every year, folks make resolutions and set goals for the new year. It would be interesting to have some real numbers comparing success in 2020 to a typical year, but I bet that many of us have failed or at least had to postpone plans and goals. I had no idea that my trip to … Read more
This year has been difficult for most of us, and it’s almost over. The lives of people throughout the world have been turned upside down. Many of us, myself included, already worked remotely, but now face a multitude of new challenges. When confronted with the looming crisis in March, Redgate thought first about the safety … Read more
Do you cringe while scrolling through social media? When have you ever felt better after scrolling? If you feel like social media is a net-loss for collective mental health, you’re not alone. We post in superabundance with flailing emotions. We flaunt our duck-faced selfies with smooth-faced filters until we don’t even look human. We hammer … Read more
Redgate has recently opened the 2021 State of Database DevOps Survey. Whether or not your organization does DevOps, I would love for you to take the survey. The survey will require around 15 minutes of your time, but I think it’s a great investment as it will benefit the whole community of database administrators, developers, and … Read more
I attended a training session at Redgate this week by Chris Spalton. Chris’ session topic was “An Introduction into Planning User Research.” Chris pointed out that there’s much more to User Research, but that planning the research is particularly important as it is the foundation for everything you do later. If you’re a database administrator … Read more