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
586 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
708 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
456 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,155 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,463 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
630 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
558 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
524 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,484 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,063 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers