Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Code
  • Presentations
  • Publications
  • Contact

Author: Josephine

Temporal Table Data Fixes

  • Posted onSeptember 5, 2023September 5, 2023
  • Azure

I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is off. Who wants to wait until off-hours to run scripts if you could devise a way…

Continue Reading

T-SQL Tuesday #165: Database Job Titles Roundup

  • Posted onAugust 15, 2023August 15, 2023
  • dba

This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still need help understanding all the database job titles, you could always make up your own, like…

Continue Reading

T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?

  • Posted onAugust 1, 2023July 31, 2023
  • datawarehousing

It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was looking for a new job, I realized that there are a lot of conceptions about what…

Continue Reading

Azure Data Studio Schema Compare Extension

  • Posted onJuly 13, 2023July 13, 2023
  • Azure

A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so it has been a great help to have this extension installed. I will show you how…

Continue Reading

Microsoft Fabric Overview

  • Posted onJuly 10, 2023July 10, 2023
  • Azure

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn more about the licensing and costs associated with Microsoft Fabric. This is all stuff you can…

Continue Reading

Restore SQL Server Backup to Docker Container

  • Posted onJune 29, 2023June 29, 2023
  • containerization

Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post. To get that setup, you can follow the instructions in this blog post. I found that…

Continue Reading

Connecting to Azure SQL DB with an Azure Active Directory Account in Azure Data Studio

  • Posted onJune 15, 2023June 15, 2023
  • Azure

This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I was logged in with Azure Active Directory – Univeral with MFA. When I Googled, I didn’t…

Continue Reading

Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data

  • Posted onJune 1, 2023June 1, 2023
  • Azure

Information security and privacy are key in today’s data-driven world. Sensitive data needs to be protected from unauthorized access. With column masking in SQL Server and Azure SQL, you can conceal sensitive data, allowing only authorized users to see it. Understanding Column Masking Column masking…

Continue Reading

Using Docker on Windows with Persistent SQL Server Settings and Databases

  • Posted onMay 15, 2023May 15, 2023
  • containerization

This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after creating your Docker container. I found that you can mount the volumes that SQL Server…

Continue Reading

Automating Database Maintenance on Azure SQL

  • Posted onMay 8, 2023May 8, 2023
  • Azure

Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes and other errors. Maintenance tasks such as index optimization and statistics updates ensure query processing happens…

Continue Reading

Posts navigation

Page 1 Page 2 … Page 21 Next Page

My Events

< October 2023 >
Mon Tue Wed Thu Fri Sat Sun
            1
2 3Ireland UG all day
4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          

Subscribe to SQL Kitty

loader

Email Address*

Name

Recent posts

  • Temporal Table Data Fixes
  • T-SQL Tuesday #165: Database Job Titles Roundup
  • T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?
  • Azure Data Studio Schema Compare Extension
  • Microsoft Fabric Overview

Categories

  • Azure (8)
  • containerization (13)
  • datawarehousing (2)
  • dba (16)
  • editorial (1)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (7)
  • other (3)
  • postgresql (5)
  • security (2)
  • SQL Server (13)
  • sql server administration (118)
    • jobs (2)
  • sql sever syntax (78)
  • web dev (6)
  • zen (2)

Archives

  • September 2023 (1)
  • August 2023 (2)
  • July 2023 (2)
  • June 2023 (3)
  • May 2023 (4)
  • April 2023 (3)
  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (4)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • Temporal Table Data Fixes
  • T-SQL Tuesday #165: Database Job Titles Roundup
  • T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?
  • Azure Data Studio Schema Compare Extension
  • Microsoft Fabric Overview
© Copyright 2023 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress