Custom Rounding and Truncation of Numbers in MDX
MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.
Is Your Server Vendor Providing the Quality, Innovation, and Support You Need?
We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.
The SQL Connectivity Team wants your opinion
Take this survey from the SQL Server developer team at Microsoft.
Installing SQL Server
Because installing SQL Server is so easy it is tempting to cut corners, fail to plan properly and blindly accept default options without considering the alternatives.
On demand creation and destruction of a Linked Server for SQL Server
Create a linked server on the fly in this tip.
DBAs and the Fear of Maintenance Plans
The Maintenance Plan wizard offers a quick and simple route to make sure essential database maintenance tasks are performed and scheduled. However, it needs to be used with a lot of care, and is no substitute for the judgment, experience and common sense of a flesh and blood DBA.
Using SSIS to Capture the File Name
This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.
Collecting Query Statistics for SQL Server 2005
With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
Support The Boss
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCP Wonosobo No.Telp:087757645171
Whatsapp:087757645171 Jl. A. Yani No.3, Wonosobo Timur, Wonosobo Tim., Kec. Wonosobo, Kabupaten Wonosobo, Jawa...
Alamat kantor resmi BCA KCU CIREBON Telp:0817629933
WhatsApp:0817629933 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Cara mengatasi lupa pasword muamalat Din hub. Wa. 082137379963
Ruko Sari Plasa Kav 1-2 Jl. Raya Bojongsari No 1 RT 02/04 Bojongsari Depok...
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