Great Developers Use Source Control
The title says it all. The great developers will use source control. This habit might not make you great, but it will help you improve.
SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python
In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.
Stairway to U-SQL Level 20: Querying External Data with U-SQL
Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.
SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
AI in Industries
It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
Intervals Part 1 - Definitions and Terms
Learn the basic terms and definitions for intervals in SQL Server.
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers