SQL Server Database Deployment: What Could Go Wrong?
Phil Factor tackles the questions you were too shy to ask about SQL Server database builds, migrations and deployments.
Storage 101: Data Center Storage Configurations
In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.
Representing uncertainty in difficult times
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
An Introduction to PowerShell for a DBA
An introduction to PowerShell that covers basics alone with some more advanced features. It will walk you through from the very beginning to the writing of a few useful scripts.
Are You Ready To Change Your Work Environment?
With many of us working from home, Steve wonders if you want to change anything.
Export SQL Server Tables to Excel
Sometimes there is a need to export data for a lot of different SQL Server tables into an Excel file. In this tip we look at how we can quickly export several tables into one Excel workbook where each table is stored in a different worksheet.
A Security Regression
Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.
DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries
Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning experience. This is useful for developers starting to learn the DAX language to more advanced developers who […]
Free Training Week: How I Use the First Responder Kit – sp_Blitz
When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.
Where AI Shines
Artificial Intelligence hasn't always worked well, but there is one place that is seems to have lots of potential.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
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....
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...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
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