Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
Introduction to Bitmasking in SQL Server, Part 2
In part 2 of his series, Lee Everest expands upon bitmasking and integrates this with the SQL CLR.
Mastering SQL Server Profiler - Part 6: Creating Custom Traces
The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.
Attribute Discretization: Using the “Equal Areas” Method
Get hands-on exposure to the use of the "Equal Areas" discretization method in Analysis Services. Join BI Architect Bill Pearson as he continues to explore Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
Book Review: What Got You Here Won't Get You There
I've been reading What Got You Here Won't Get You There by Marshall Goldsmith over the past couple months, and found it to be a useful book. My one sentence summary is that it teaches without the ability to be introspective and let go of your pride,...
Evolution and Technology: Data Warehouse Infrastructure
A look an evolution of infrastructures from Bill Immon.
Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
Creating a recycle bin for SQL Server 2005\2008
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU DARMO Telp/Wa:0817.839.777
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
BCA KCU JEMBER Telp/Wa:0817.839.777
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
BCA KCU INDRAPURA Telp/Wa:0817839777
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers