Help I’m an Oracle guy – whats all this SQL Server stuff ?
Having ventured into both the SQL Server world and the depths of Oracle RDBMS – Im often asked what the differences...
2012-05-18
743 reads
Justin H-Davies
To contract or not to contract – that is the question !
I’ve been deliberating over the last few years whether to make the leap into the contracting/consulting world.
Speaking to a good...
2012-05-18
783 reads
I’m back !
Hello Everyone – its been a while.
I’ve been out of the blogging scene over the last year or so due to...
2012-05-12
661 reads
New Diagnostic Manager functionality
The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives...
2011-05-06
1,022 reads
Daily Denali Delight – Day 6
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-28
799 reads
DevConnections – Heavily Discounted Passes !
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first...
2011-04-28
696 reads
Daily Denali Delight – Day 5
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-27
983 reads
Daily Denali Delight – Day 4
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-26
963 reads
Daily Denali Delight – Day 2
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
750 reads
Daily Denali Delight – Day 3
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
784 reads
Blogs
Understanding Lakehouse Permissions in Microsoft Fabric
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
The Cost of Not Having a DBA
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Forums
Union where it matches against only one shared column
Hi folks I have two tables, both with a NAME, START and END fields...
How to update using data from three tables?
I am in the process of migrating from MySQL to SQL Server. I have...
Select Returning Blank Rows
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers