How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
544 reads
Blog Posts
How to use CISL – the Columnstore Indexes Scripts Library
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes...
2015-12-22
871 reads
Immunizations – Not Just for Kids
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
639 reads
Reflections and Looking Forward
Time is slowly ticking toward 0:00 on the clock. As I look around I couldn’t help but reflect back on...
2015-12-22
497 reads
The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'
I have recently had a client with a problem each morning where they were having processes fail with this message...
2015-12-22
19,928 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,790 reads
Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
919 reads
Fixing Truncation Issues with T-SQL Flex
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
1,023 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
965 reads
Monday Morning SQL Break – December 21, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-21
452 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers