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
- Interests: cooking, F1 grand prix, internet, mobile apps
HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 2
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
Thank you very much
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
Connection pooling and the DBA
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
Identifying Columns to Create Index via T-SQL
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
SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
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
70-457 Reviewer #16 Implement AlwaysOn in SQL Server 2012
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
Checking your users and groups in Command Window.
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
Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,312 reads
Troubleshooting Database Mirroring Configuration
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,024 reads
Blogs
Registered for the Data Community Summit
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
Daily Coping 5 Oct 2022
By Steve Jones
Today’s coping tip is to choose to see your mistakes as steps to help...
Restore HEADERONLY and FILELISTONLY
By gbargsley
Good day reader. This post is coming to you from a busy week in...
Forums
Change tracking - Date a row changed
We have change tracking enabled on one of our databases and I am looking...
Grant user permissions to a view but the base tables live in another database
I have two databases on the same server. I have a service account I...
The ORDER BY clause is invalid in views
Hi, I'm trying to run the below SQL code but I'm getting this error:...
Ask SSC