Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.
We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.
This week Steve Jones wonders if you'd be willing to use Express edition in production situations.
The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.
SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.
Today Steve Jones talks about development, and finding ways to make small changes that improve your code.
An article about how we underestimate the power of joins and degrade our query performance by not using proper joins
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Call Center/Telpon 083179431323 Jl. Moh. Hatta No.29, Lolu Utara, Kec. Palu Sel., Kota Palu,...
Whatsapp:087757645171 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah Besar, Kota...
Call Center/Telpon 083179431323 HMMF+G8F, Jl. Diponegoro Dalam, Madras Hulu, Kec. Medan Polonia, Kota Medan,...
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers