I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading| SQL Studies
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading| SQL Studies
Introducción Una tarea común para los novatos es poder aprender cómo hacer una conversión de fecha de SQL y trabajar para convertir la fecha a otros tipos de datos o transformar otros tipos de datos a la fecha. Aquí en este artículo explicaremos cómo trabajar y convertir fechas a diferentes formatos o viceversa. Requisitos Tener […]| SQL Shack – articles about database auditing, server performance, data reco...
Este artículo es un esfuerzo para discutir y analizar las funciones de conversión de SQL y convertir SQL como parte de un seguimiento y actualización de los artículos anteriores, en el que hemos discutido varias sugerencias de SQL, como SQL fecha, SQL Coalesce, Unión SQL, SQL Join, SQL igual, Cadena SQL etc. En algunas ocasiones […]| SQL Shack – articles about database auditing, server performance, data reco...
It’s another T-SQL Tuesday! Our host this month is Taiob Ali (b). (Thanks for hosting this month, Taiob!) He’s asked us to talk about how AI is changing our careers. The pressure is def…| Deb the DBA
Have you ever heard of stolen memory in SQL Server? I’ve never had any significant issues with stolen memory myself, but I thought it would make for a good blog post. Let’s take a look …| Chad Callihan
After the successful release of Public Preview of mssql-python driver, we’re thrilled to announce a major milestone for the mssql-python driver: full support for all three major operating systems—Windows, macOS, and Linux. This release marks a significant leap forward in our mission to provide seamless, performant, and Pythonic connectivity to Microsoft SQL Server and the […] The post Announcing Full Cross-Platform Support for the mssql-python Driver appeared first on Microsoft for Pyth...| Microsoft for Python Developers Blog
With the announcement of SQL Server 2025 Public Preview, hopefully you are interested in test driving Vector Search. Microsoft has already posted demo code, but it’s only for OpenAI on Azure.…| Every Byte Counts
It’s time for another video! This time, it’s getting started with using vectors and vector searches in SQL Server 2025, which just went into public preview. Let me know your thoughts! If you want to get started, here are some references for SQL Server 2025:| Deb the DBA
Happy T-SQL Tuesday! This month, Andy Levy (bsky | blog) has asked us: How do you manage and/or monitor your SQL Server Agent jobs? (Check out the full invite here.) When I first got started as a D…| Deb the DBA
Have you ever wanted to know how to create a parquet file directly from your SQL Server 2022 instance? Did you even know that it was an option? Setting this up sounds like it would be really complicated, but it’s much simpler than it seems. Join me as I show you how: As I mention […]| Deb the DBA
Happy T-SQL Tuesday! This month, Steve Jones (blog | Bluesky) asks how we track and manage permissions. I want to throw in a quick aside to give a big thanks to Steve, who took over T-SQL Tuesdays many years and has been keeping it on track and running month after month. Now back to the […]| Deb the DBA
When I went to find the iconic books to learn the .NET stack I came to a shocking realization. There are too many books! 53 books; 30,656 pages; over 757 hours.| Kerrick Long's Blog - Articles about programming, learning, code, books, and ...
This article will show the SQL IN operator with examples.| SQL Shack - articles about database auditing, server performance, data recove...
This article will provide an understanding of finding duplicates in SQL.| SQL Shack - articles about database auditing, server performance, data recove...
This article will show the difference between SQL SELECT UNIQUE and SELECT DISTINCT.| SQL Shack - articles about database auditing, server performance, data recove...
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with Steve). Because of this, I’m going to bend the rules a little (sorry Steve) and give you a few days to get your posts together. In […]| Grant Fritchey
In this article, we will learn about one of the important statistical functions, the SQL Standard Deviation function.| SQL Shack - articles about database auditing, server performance, data recove...
This article will show the Group By clause, what it does and why we use this in SQL queries.| SQL Shack - articles about database auditing, server performance, data recove...
