Tags » SQL Server

SSIS 2012 – Package Configurations Menu Option Missing

I am posting this because I came across the same thing. As the original author states – maybe it will be useful for someone else. 8 more words

ISPACs - Got To Love Em

Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). 497 more words

SQL Server

Giving Permissions to BUILTIN\Users in SQL Server

I had a script for granting access to a SQL Server Express database to all users that looked like this:

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'BUILTIN\Users')
BEGIN
	CREATE USER  FOR LOGIN 
	EXEC sp_addrolemember N'db_datareader', N'BUILTIN\Users'
	EXEC sp_addrolemember N'db_datawriter', N'BUILTIN\Users'
	GRANT EXECUTE TO 
END
…
149 more words

SQL Server

Installing SharePoint 2013 on Network Load Balance windows server 2012

Our lab scenario

Configure NLB between the 2 servers which play as a SharePoint servers

http://helmymo7amed.wordpress.com/2014/07/16/windows-server-2012-r2-network-load-balancing-nlb/

Install a SQL Server which will contain the SharePoint Database… 187 more words

SQL Server

SQL SERVER - Cardinality Estimation and Performance - SQL in Sixty Seconds #072

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query.  154 more words

SQL Authority

SQL Server Query - To find rows that contain only numerical data

Click Here for complete List.

In this post let us see a SQL Query to retrieve only the numeric rows from the table.

We use the ISNUMERIC function available in SQL Server. 212 more words

SQL SERVER

Another session selected

This time in Oslo. (http://sqlsaturday.com/317/eventhome.aspx)
I hear Norway is nice this time of the year, and my aunt was eaten by a moose… 27 more words

SQL Server