Before computers, the British, US and Canadians all entered dates with the full month-name first, followed by the day number, followed by an ordinal suffix (1st, 2nd, 3rd and 4th etc) followed by the year. It was generally the full four-figure year. I know all this because I’ve just been converting many thousands of these … Read more
Today the internet is completely associate with large source of data. Inappropriately, the huge majority of it isn’t out there in handily organized CSV files for download and analysis. If you want to capture data from several websites, you’ll have to be compelled to strive web scraping. It helps them to learn about operational activities, also … Read more
A feature I have never actually used professionally is filestream and filetable. We have a few file based solutions, but they are all packaged solutions. It is a feature that has intrigued me since it was released, but it has never been a fit for the kind of work I typically do (mostly transactions and … Read more
This article explains about how the data modifications is handled by Cassandra, to handle Update’s and Delete is effectively we need to first understand the Write Path and the Read Path in Cassandra. The Write Path When a write request (insert) is received is by Cassandra, the data will be stored in Memtable & Commit … Read more
I wrote before about how to check index usage on the database, in that article I wrote about exploring query plans. However, another reason to check index usage would be to drop indexes not being used. Every index create some level of impact on changes (INSERT/UPDATE/DELETE) and if an index is not being useful, it … Read more
Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback in the form of errors returned. Potential problems with … Read more
When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it is taking the pictures. The HARD part is deciding what to post every day. So instead of picking things from my head, I decided to harness … Read more
Microsoft Build took place more than a month ago, but only now I’m writting about it. I’m facing the danger of being nicknamed as one famous Brazilian formula 1 pilot. Internal Brazilian joke. Build is a historical mark among community events. It implemented many new techniques to make an online event closer to an in-person … Read more
Introduction Digital transformation is the process of undergoing multiple internal and external changes by an organization leveraging digital technologies to become more agile, optimized and efficient in its business operations. Dynamic IT environment, the urge to leverage emerging technologies, and the unpreparedness to function at scale in throes of the global pandemic are driving increased … Read more
Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is there a row in inserted/deleted that is not set up as desired for the current transaction?” and no bad data is found, keep moving. And because MOST of the time, you would only use a … Read more
Once upon a time, we got the Data Warehouse concept. A concept as great as difficult to implement. The definition of this concept may surprise you nowadays: the Data Warehouse is a collection of structured and unstructured data. The structured data is what we usually know, but what happened to the unstructured data on this … Read more
Some tasks on azure are easier if we automate them. The Azure Portal provides us the cloud shell, which we can use for this kind of automation. I was making some experiences with SQL Server Always On, so I created three VMs inside a resouce group. Every time I want to start some experiment I … Read more
As I have been writing a section on SQL Server graph tables in my Database Design book, (and prepping for a hopeful book on the subject next year), I find that there are a few really annoying things about dealing with graph tables. This blog serves to clear up the first, most annoying of them. … Read more
SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT can make you go mad very easily. The schema compare has a lot of configurations. A really lot of configurations. You start the schema compare using the right-click on the SSDT project. Before starting the … Read more
How do you get your database schema changes live on your production system? As your team of developers and DBAs work on changes to the database to support your business-critical applications, how do updates wend their way through dev environments, possibly to QA, hopefully through pre-production and eventually to production in a controlled, reliable and … Read more
There are many situations when you need to extract a DACPAC from an existing database in a SQL Server. These situations are usually related to devOps, we extract the DACPAC to make schema comparisons, generate scripts for schema deployment or deploy directly the DACPAC. It can be used in many different ways during a devOps … Read more
In SDLC (software development life cycle) process, creating a batch job is the last step. As the application maintenance grows over period of time and new component added to the overall process can make over batch support complicated. This article provides guidelines to create batch jobs that can be well supported in future. Though this … Read more
If you are working on any module or routine such as a procedure, function or batch that produces a result, then you will want to compare it with something that you’ve prepared earlier to make sure that it is the same. It is often necessary to compare objects, particularly when you are working on a … Read more
Before taking any time with the rest of my SQL Saturday Chattanooga, Home Edition teammates to discuss what went right and wrong with our event (it felt mostly right, honestly as far as I could tell, but we won’t totally know until we get the feedback from attendees), I was thinking as I was enjoying the … Read more
One of the coolest and most useful features of Azure Data Studio (ADS) is SQL Notebooks. If you haven’t seen them, notebooks allow you to combine text with markdown and runnable code in the same document, and they are shareable. Notebooks might be used for teaching, documentation, or runbooks among other uses. I recently heard … 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
