Cross Apply Ambiguity
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today after a few hours...
2010-03-26
1,926 reads
Blog Posts
Indexed Views
Views are used quite often within SQL Server for a number of reasons. They can be used to restrict access...
2010-03-26
460 reads
Learning About Microsoft Certified Master: SQL Server
Among the Microsoft certifications, the Microsoft Certified Master is the apex of all of them except maybe the Microsoft Certified...
2010-03-26
1,676 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-26
915 reads
SQL Saturday - Columbia
I've talked about trying to do a SQL Saturday event in Columbia, SC, for the last couple of years, ever...
2010-03-26
674 reads
SQL Saturday #29 Presentations & Twittering
Tomorrow, I’m presenting a couple of sessions at SQLSaturday #29 in Birmingham, Alabama. Here are the presentation materials I’ll use.
SQL...
2010-03-26
562 reads
A Fan and a Friend
I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group...
2010-03-25
687 reads
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
653 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
532 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,083 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
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...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
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