Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
4,555 reads
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
17,079 reads
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
2,247 reads
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
By Brian Kelley
In parallel with the presentation I gave at the PASS Data Community Summit on...
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...
Recently I was asked to investigate the update statistics process on a particular database....
Comments posted to this topic are about the item Adding a Lot of Seconds
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers