UNION ALL returning incorrect results?I recently came across an interesting behaviour when executing queries that included a UNION ALL statement, the examples below were created using SQL Server 2016 Service Pack 1.
SQL Server 2017 will change how we think about it
The next version of Microsoft’s heavyweight database platform came one step closer to arriving this week when Microsoft released Release Candidate 1 of SQL Server 2017. Microsoft usually provides a couple of release candidates, meaning the final version is likely to appear sometime this autumn.
10 Considerations when designing a data platform
1. New technology
This does not mean implement every possible new feature or design methodology, but that enough knowledge is gained so that the most appropriate decisions are taken when building the foundation of a solution. Existing functionality may already be offered as part of a 3rd party..
PowerApps – 500 Record Limit, Delegation and How to Work Around it
Update - April 2018:
PowerApps now has an experimental feature that can be turned on to increase the 500 row limit. I've not tested it with large sets but its a nice step forward.
To increase the limit, in the app developer studio (web or desktop) go to File->App Settings->Experimental Features and..
Why Don't You Unit Test SQL Server Code?
"The best time to plant a tree is twenty years ago, the second-best time is now" Chinese Proverb
Learn to query SQL Server databases
I’m increasingly meeting people at data and tech community events who need to query SQL Server databases, but who don’t need to know how the database engine works, how to create databases – in fact how to do anything other than connect and retrieve data. That can be a problem for some training..
Using an Azure cloud witness in your failover cluster
I’ve blogged previously about the need to configure a quorum witness on failover clusters and now with Windows Server 2016 there’s a great new quorum option – a cloud witness.
Introducing Always Encrypted
With the General Data Protection Regulation (GDPR) becoming a focus point for many organisations, data owners are investing in ways to better protect their customers' data. Microsoft has invested heavily in a range of new security capabilities in SQL Server 2016 such as Row-Level Security, Dynamic..
The importance of bringing Python to SQL Server
Microsoft proudly announced this week that SQL Server 2017 will be the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also..