TSQL Challenge 18 - Generate text formatted month calendars
Can you generate a calendar with T-SQL? Take this month's challenge.
2009-11-30
3,924 reads
Press Release
The WorkTamer Conference
The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.
2009-11-19
295 reads
TSQL Challenge 17 - Creating cross rows references with inline hyperlinks
Here is a real world scenario I came across on the MSDN forums. The forum poster wanted a method to dynamically create HTML hyperlinks, for keywords/phrases , within the description of the current column text. Enter this challenge and see how your T-SQL skills match up.
2009-11-16
2,633 reads
2009-11-06
28 reads
The ADO.NET Managed Providers team wants to hear your opinion
Take this survey and help out the Managed Provider team at Microsoft.
2009-11-05
797 reads
Top Ten Reasons to Attend the 2009 PASS Community Summit
There are some good reasons to think about attending the 2009 PASS Community Summit.
2009-10-22 (first published: 2009-03-24)
4,549 reads
SQL Bits IV
Coming to Newport in the UK on Nov 19-21, be sure to register and attend if you are nearby. A few days of great SQL Server training.
2009-10-21 (first published: 2009-09-21)
1,906 reads
Data Cleansing with the SSIS Data Flow
A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.
2009-10-21 (first published: 2009-10-19)
5,648 reads
Ask SQLServerCentral
We have expanded our forums with a new Question and Answer site based on the StackOverflow codebase. Please feel free to visit.
2009-10-12 (first published: 2009-10-09)
863 reads
The SQL Connectivity Team wants your opinion
Take this survey from the SQL Server developer team at Microsoft.
2009-10-06
901 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers