TSQL Challenge 72 - Calculate the Payroll Hours of Employees
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
2011-12-26
1,824 reads
Articles
Administrating SQL Server Integration Services - Planning, Documenting and Troubleshooting
SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and occasional tasks. It majors on ETL tasks and for administrative jobs across servers. The DBA needs also to be aware of their role in optimising SSIS by planning, trouble-shooting, optimising performance, and in documenting installations.
2011-12-26
3,146 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
2011-12-23 (first published: 2009-07-20)
40,554 reads
Window Functions in SQL Server: Part 2 - The Frame
Fabiano Amorim continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented and when, and explaining the concept of the 'Frame' in a window function, with plenty of examples.
2011-12-23
3,169 reads
Display Complex Hierarchical Data with Server-Side Pagination
This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.
2011-12-22
8,581 reads
2011-12-22 (first published: 2010-05-26)
11,698 reads
Backing Up a SQL Server Database Directly Onto a Remote Server
Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy
2011-12-22
3,325 reads
Red Gate Software announces DBA in Space competition winner
Find out who has been announced as the winner of Red Gate Software's DBA in Space competition.
2011-12-21
6,026 reads
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”
2011-12-21
2,509 reads
Managing Data Dictionaries in DW and DSS Database Applications
Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.
2011-12-20
6,524 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA Finance Kelapa Gading Layanan Mobil Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp....
BCA Finance Seasons City Layanan Mobil Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Seasons City Mall, Jalan Prof. Dr. Latumenten V No.33 Lt LG, RT.13/RW.1, Jemb....
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers