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
594 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
713 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
459 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,164 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,468 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
631 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
565 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
525 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,500 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,066 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers