Reporting v Editing
In response to his article on using Reporting Services to manage rights, Jonathan Spink takes a look at how Reporting Services can be positioned in your enterprise.
2006-09-12
5,221 reads
Articles
Speak Like a T-SQL Developer
In this video by Kathi Kellenberger, she starts beginners interested in T-SQL programming the teminology and some of the basiics of T-SQL. She also covers the what the various editions of SQL Server mean and the tools that you will use.
2006-09-12
3,036 reads
Identifying Unused Objects in a Database
Longtime author Leo Peysakhovich answers one of the most common questions seen in discussion areas around the world: how do you identify unused objects?
2006-09-11
26,584 reads
SQL Server 2005 Integration Services - Message Queue Task - Part 32
After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, part 32 of this series focuses on individual components that have more specialized, but very useful characteristics, starting by discussing the Message Queue Control Flow task, and following with coverage of a number of Data Flow transformations.
2006-09-11
1,581 reads
Detroit Area SQL Server User Group
The next meeting of the Detroit Area SQL Server User Group is September 14th.
2006-09-08
1,646 reads
Learning SQL Server 2005
Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.
2006-09-08 (first published: 2005-04-21)
45,324 reads
Copying Database Backups to an Alternative Location
Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.
2006-09-08
4,926 reads
Windows Utilities for the SQL Server DBA
This article is a short summary of Windows utilities both GUI and command line intended for new SQL Server DBAs or those interested in learning some useful techniques.
2006-09-07
18,497 reads
SQL Server 2005 Common Table Expressions
A CTE is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temp tables, cursors, and so on.
2006-09-07
2,652 reads
Controlling Jobs
Have you ever needed to build a job that could run within a certain period of time? Those long maintenance operations, like index rebuilds, need to fit within certain windows of time. New author Joe Doherty brings us a great technique for ensuring those jobs do not run over into your business day and impact normal operations.
2006-09-06
8,383 reads
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
Alamat kontak resmi BCA KCU PURWODADI | Telp: 0817825533
phone, Wa: 0817825533, Jl. MT. Haryono No.2, Jengglong Timur, Purwodadi, Kec. Purwodadi, Kabupaten Grobogan,...
Alamat kontak resmi BCA KCU SOLO SLAMET RIYADI | Telp: 0817825533
phone, Wa: 0817825533, Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota...
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
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