HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
574 reads
Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...
2013-12-24
574 reads
Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to...
2013-12-24
697 reads
This year has been so awesome!! I hope to do better in the coming year and be able to share...
2013-12-24
450 reads
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,144 reads
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,446 reads
Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...
2013-11-26
620 reads
This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...
2013-11-17
549 reads
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
516 reads
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,327 reads
From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...
2013-11-11
1,027 reads
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
I would like to know what certifications or paths to choose in order to...
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...