SQL Server SEQUENCE Basics
The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is a great relief to database professionals as it solves some problems what are awkward to solve with the IDENTITY property. Joe Celko explains the basics of using a SEQUENCE.
The Security of Interconnected Systems
We are interconnecting more and more computer systems and applications all the time. Security becomes a problem when one of these systems hasn't been properly configured, secured, or coded. Steve Jones notes this is becoming a real problem.
SQL Saturday #268 New Haven, CT
SQL Saturday is coming to New Haven, Connecticut on March 01, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services
Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
Backup and Housekeeping with Maintenance Plans
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
Collect Your SQL Server Auditing and Troubleshooting Information Automatically
If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of databases, and you want to be alerted about a number of diverse events that are useful for first-line problem-diagnosis and auditing, then Feodor's homebrew solution, using SSIS and Robocopy is likely to be what you're looking for.
Calendar Tables
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Finance WTC Mangga Dua Hub.0853•5504•2311
BCA Finance WTC Mangga Dua Hub.0853•5504•2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
BCA KCP Arundina Cibubur Hub.0853•5504•2311
BCA KCP Arundina Cibubur Hub.0853•5504•2311 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
BCA KCP Riau Bisnis Center TLP/WA 08216977749
Jl. Riau No.36, Tampan, Kec. Payung Sekaki, Kota Pekanbaru, Riau 28292
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers