SQL Server Replication Crib Sheet
Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.
The May Car Update (2007)
Steve Jones takes a look at the world of automobiles and specifically his new Prius hybrid.
Upload multiple XML files to an XML data type column
Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.
Best Practices for Date/Time Calculations in SQL Server
You can use arithmetic operators in date/time calculations in SQL Server, but sometimes the date/time functions provided by Microsoft are the better option. Follow a few scenarios that demonstrate when arithmetic operators are safe and when they are risky.
Gathering RSS Feeds using Visual Studio and RSS.NET
If you would like to learn how to build and customize your very own Windows service to retrieve posts from multiple RSS feeds, and then store those posts in a SQL Server database, let John Papa guide you through his tutorial.
Generating lift reports using Reporting Services - Part 1
This tip explores a DMX extension introduced in SQL Server 2005 SP2 that can be used to render lift reports directly in Reporting Services.
Career Book Reviews
Working in the corporate world can be a challenge and most of us muddle through our careers without really having any formal training. Andy Warren has spent time proactively working on his career and learned a great many tips and tricks for succeeeding as an employee and a manager. He brings us a few book reviews that might help you cope with the strange corporate world in which so many of us work.
Conditional Formatting in the Analysis Services Layer
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.
Implementing Real-World Data Input Validation using Regular Expression
Francis Norton shows how to use regular expressions to fulfil some real world data validation requirements, demonstrating techniques ranging from simple number format checks, to complex string validation that requires use of regex's powerful "lookahead" feature.
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
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...
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