Introduction:
Who is not aware of a SQL Database? It was the first business language introduced for E.F Codd’s Relational Database management system. In addition, MySQL, Oracle, Informix, Sybase, MS...
2020-02-20 (first published: 2020-02-12)
1,450 reads
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...
2020-02-20 (first published: 2020-02-12)
450 reads
I just completed a chapter for another book where I spoke about the Recovery Point Objective (how much data you are prepared to lose) and Recovery Time Objective (how...
2020-02-19
34 reads
With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created...
2020-02-19 (first published: 2020-02-11)
2,993 reads
Jess Pomfret is hosting month’s T-SQL Tuesday, and asked us to share our favorite life hacks – something that makes our day easier. I have a few,some people have told...
2020-02-19 (first published: 2020-02-12)
541 reads
I am very excited and fortunate to be chosen to speak at both SQLBits and DataGrillen this year. These two conferences are incredible community run events and if you...
2020-02-19
10 reads
Having worked with Azure SQL Database and its many flavours for couple of years now I am confident in building deploying, whether manual or templates. Being in Azure you...
2020-02-18
23 reads
Simply put, we are not always going to agree. Please, take this as someone who was nicknamed “The Scary DBA” for reasons comic and tragic. I’ve screwed up a...
2020-02-18 (first published: 2020-02-11)
475 reads
Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing ... Continue reading
2020-02-18 (first published: 2020-02-11)
641 reads
Last week I was excited to receive an email from Redgate notifying me that I have been renewed for another year as a Friend of Redgate. Our shop has...
2020-02-18
17 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers