SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,764 reads
PracticalSQLDba
SQL Server: List Explicit Permission on Database for Login and Database Role
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,496 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,289 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,991 reads
SQL Server : List Login's Database and Server Level Role Permission
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,525 reads
SQL Server : Fixing the Orphaned Users
In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...
2012-08-02
1,447 reads
SQL Server:Finding the Orphaned Users
Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...
2012-08-02
1,715 reads
SQL Server : Implementation of Table Valued Parameter (TVP)
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,338 reads
SQL Server : Dedicated Administrator Connections
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,747 reads
Windows Cluster: Moving Quorum Disk to Another Node
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,393 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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