Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
419 reads
Blog Posts
Azure SQL Database / SQL Server – Paused Index Rebuild
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,889 reads
Backup and Restore Automation using SQLCMD and SQL Server agent
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
450 reads
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
452 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
365 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
797 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
589 reads
Lost that SQL Server Access?
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
21 reads
Lost that SQL Server Access?
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
877 reads
The Importance of ORDER BY
Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...
2018-05-30
422 reads
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