SQL Saturday #59 - New York City
A free day of training in New York City just before Thanksgiving. Come see Steve Jones and Grant Fritchey, along with a number of other great speakers.
Learning Sharepoint, SSIS and SSAS
Steve Jones outlines some ways that you might look to get additional training that can help move your career along.
Proving Your Identity
We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.
The Next Step for SQL Server
This past week saw the next version of SQL Server, code named Denali, released as a public CTP. Steve Jones comments on the new version.
Setting up Transactional Replication in SQL Server 2008 R2
Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This article provides a step by step guide to setting up transactional replication on SQL Server 2008 R2.
An Example of Test-Driven Development, Part 3
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
More Triggers
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
SQL Server R2 in Luxembourg
On Nov 16, 2008, the Luxembourg SQL Server User Group will hold a SQL Server 2008 R2 event in conjunction with Microsoft.
Getting Started with Extended Events in SQL Server 2008
In a previous tip, we did an overview of Extended Events and the different components that make up Extended Events. Now that you know what Extended Events offers, how do you use it to help troubleshoot performance issues? In this tip we take a step by step look at how to implement and use Extended Events.
Live Monitoring
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Godean | Tlp/Wa:0818751777
Jl. Godean No.Km 4,5, Area Sawah, Nogotirto, Kec. Gamping, Kabupaten Sleman, Daerah Istimewa Yogyakarta...
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers