This blog is different than my normal T-SQL blogs I almost always do. But I know that I cannot be the only computer programmer who wants to wear a smart watch when working to get some of the health and alert benefits that they can provide. The band though, has always been a blocker to … Read more
Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. One of these tasks, for example, is the merge of two tables. Even in the same dataflow, if you have two tables and make the merge, … Read more
Recently, we started adding compression to some of our larger tables in our data warehouse where columnstore indexes didn’t make sense. (For example, some very large dimension tables, and a few facts where they are not used for large aggregates in the common manner). The changes were checked into source control, we monitored performance, all … Read more
It has been a fun summer, sort of. 13 weeks ago, I had my left knee replaced to balance out my other two hip replacements on my right side. This is hopefully the last time that Dr Morrison of Southern Joint Replacement Institute ever has to cut into parts of my body with power tools. … Read more
I don’t know when I first heard about Redgate, but it might have been in 2005 when Steve Jones asked me to review their product, SQL Backup, for SQL Server Central. It was quite the coincidence when my manager asked me a few weeks later if I had heard of SQL Backup and would I … Read more
Once upon a time a SQL Server version that hadn’t row locks. The minimal level of lock was page lock, every time you want to lock a record, an entire page was locked. At that time we were between the devil and the deep sea: if we choose a clustered index with an ascending key … Read more
UPDATE: Read the full report here. Recently, over 800 participants across a range of sectors and from all around the globe took part in a survey about the state of SQL Server monitoring. This survey from Redgate Software is the only one of its kind and is in its second year. Here are some significant … Read more
I nowadays enjoy working with front-end developers using JavaScript, especially now that SQL Server has the tools that allow the SQL Developer to accommodate their requirements. There is less tension now, because if the SQL Server developer can deliver exactly what they need, then there is less temptation to allow users access to base tables, … Read more
My dad and I had a very interesting and complex relationship. Some of this was due to his complex upbringing. His father was an alcoholic who died fairly early in his life, and his mom, well, his mom liked me a lot, but she was a messed up woman in many ways. After his father … Read more
Coming up this weekend, I will be in Virginia Beach, VA for their first ever SQL Saturday event. I have strong ties to the area, as the company I work for is located there, and they are helping me out to be able to come in for the event at a more reasonable pace than … Read more
Ok, so I have been, and will mostly stay, in a bit of blog hibernation. I am super busy trying to finish up a rather large number of tasks (a few chapters in a book, 2 more SQL Saturdays, and as much theme park time as I can get in before the end of June, … Read more
As a companion script with my recent article about Scripting out several databases on a server, here is a similar script that either scripts out the data for the SQL Server tables you specify as insert statements, or else as native BCP files if they are too large for insert statements. The purpose of scripting out the … Read more
MongoDB has a prodigious appetite for unstructured data and has its place in a Database Developer’s toolkit. Even with indexes in place, some operations that involve aggregation are a lot slower than they are with relational databases: So it is when using ‘joins’ between collections. Lookup, the MongoDB equivalent to Joins, cannot yet do Merge … Read more
SQL Saturday Jacksonville this weekend! Coming up this weekend, on the least holiest, but still very awesome holiday (May the Fourth), I will be in Jacksonville, Florida delivering a couple of sessions. Now, you might say: “Louis, why would you be travelling on May 4?” Check out the logo for Jacksonville’s event: That’s right, since … Read more
In today’s world, a user interacts with various apps/websites which require them to login or sign up via using their email address. There are a high chances of a person forgetting the username and the associated password to login or just completely giving up the sign up process as it asks a lot of information. … Read more
It is all to easy to build a database on a server and then expect it to be fully functional. Not so fast: There are a number of possibilities in terms of server-based functionality that can defeat you. Databases are likely to have scheduled jobs and alerts, and may have server triggers or even message … Read more
While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s an interesting challenge with many possible uses, so I decided to create a function to solve this problem. The Main Expression First, let’s understand the main expression to solve the problem. The path is everything … Read more
From SQL Server 2017, it becomes more practical to use JSON arrays for representing and processing a matrix. SQL Server can read them, and update values in them but can’t create them. To do this, you have to create the JSON as a string. The great advantage of them is that you can pass them … Read more
One of the common problems when you are developing databases is knowing what’s changed and when. You want to detect changes and to work out what has changed in a particular build. You’d have thought it would be an easy problem, when you consider that every database object in SQL Server’s system views has a … Read more
A few weeks ago, a coworker had a scenario where he was trying to import a large amount of data into some format (I think it was JSON, but I think it was a special limitation… that isn’t really important to the solution), and it didn’t allow certain characters. Narrowing down what the bad character … Read more
Simple Talk Bloggers
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
