Tags » SQLSERVER

How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the  Microsoft Customer Service and Support (CSS) SQL Support team members. 34 more words

SQLServer

SQL Server Security Permissions

The following script can be used to view all user accounts and their entitlements

USE master
GO
SET nocount ON

-- Get all roles
CREATE TABLE #temp_srvrole… 479 more words

SQL

SQLSat403 - Recap

The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. 910 more words

SQLServerPedia Syndication

Tips for Exam 70-462: make your labs using Azure trial

The complexity of certification exams is climbing up lately – up to the clouds. Gone are the days where a simple 3 VM lab was enough to try out every new tech release to newer versions of some product – SQL Server in this case. 106 more words

SQLServer

Recipe - Allow remote connections to SQL-Server Express 2014 on Windows 2012R2

Time for a small recipe of what I needed to do, to get a SQL-Server Express 2014 instance, running on Windows 2012R2, accessible from a remote machine. 225 more words

Development

5 SqlServer FAQs..

1>How to insert into a table with just one IDENTITY column?????

ANS—-INSERT INTO tblSTUDENT DEFAULT VALUES;

2> List records with duplicate employee name???????

Ans– SELECT e.Ename FROM Employee e… 91 more words

SqlServer

#0360 – SQL Server – sp_attach_db v/s CREATE DATABASE FOR ATTACH – Number of files limitation; Msg. 8144 (Procedure has too many arguments specified)

This post has been a long time coming. I am an advocate of using newer T-SQL and administrative features if situation and compatibility related business requirements allow. 1,021 more words

#SQLServer