Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
There is a need to ensure we decide what ethics a computer system ought to have.
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
Now in it’s 4th year, the State of Database DevOps report continues to deliver valuable insights. In the report, you will learn multiple tactics to improve the quality of database code deployment, whether it is by changing the type of environment used for development, enhancing your code review practices, or your change management/approval practices.
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.
Today, Kendra Little talks about code reviews and why they should be done early.
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.
I am very passionate about having a disaster recovery architecture, plan and strategy. This...
I had the pleasure of presenting a full-day pre-conference session on the Friday before...
By Will Assaf
Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...
Hi, Need some quick help here. I am unable to shrink tempdb files. There...
Hi, I am having the following query to fetch day & year of a...
Team My requirement is to convert column values into single row comma separator along...
Ask SSC