Articles having tag: SQL SERVER

What SQL Server 2012 Means for PHP Developers

Last week, Microsoft held a virtual conference to announce the availability of SQL Server 2012. The conference included a number of events (speakers, videos, training activities, etc.) that focused on the new functionality available in this release . Now that...

Microsoft Dynamics CRM 2011 / 4.0 Configuration in Case of Machine rename / CRM Database server change / Domain Controller Change

By NavaidAkhtar

I had wierd issue while running MS CRM 2011 after I changed the machine name. I would like to share the configurations with you that I did for my case and hope that it will be helpful for you too....(read more)

Microsoft Drivers 3.0 for PHP for SQL Server Released to Web!

By The Official Microsoft IIS Site

Dear SQL Server Developer Community, We wanted to extend a massive ‘thank you’ to the community in providing feedback for our release of our Customer Technology Preview back in September, and we’ve been working hard to incorporate the feedback...

Get random row from the table

Sometimes it happens that we need random row (or set of randoms rows) from table. Itzik Ben-Gan shows us, in one of his book, the efficient way to do this:

Exploring SSMS - Inserting Code snippets for Objects

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to insert code template for creating...

New Pluralsight Course: Building ASP.NET MVC Apps with EF Code First, HTML5, and jQuery

By dwahlin

I just finished up a new Pluralsight course titledBuilding ASP.NET MVC Apps with EF Code First, HTML5, and jQuerythat I'm really excited about. As the title implies, the course provides an end to end look at an application built using ASP.NET MVC, Entity...

CREATE SCHEMA statement must be the only statement in the batch

Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help my...

Change location of database file + correct logical file name of the database file

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this I had to...

Exploring SSMS - Hiding System databases

SQL Server - Split Database Full Backup to Multiple files

As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size of the databases it is require...