DotNetShoutout

SQL

5
shouts

Shout it

Linq to Sql – How-to Separate the entities and the DataContext.

published 11 hours, 20 minutes ago posted by

http://daniel.wertheim.se/ 1 day, 10 hours, 29 minutes ago

Linq to Sql – How-to Separate the entities and the DataContext.

Yesterday we started to use Linq to Sql in a project at work. We didn’t select NHibernate but kind of wanted a clean model anyway, where the entities are separated and not bundled in the same class as the context. We also wanted clean entities: No partial methods; No (by us) unused INotify-interfaces. We also wanted the DataContext to live in an own assembly, so it’s not included in the assembly that holds the entities. Ok, so whith al these demands you probably think that NHibernate would be a better ch... (more)

category: SQL | clicked: 47 | comment | | source: daniel.wertheim.se

tags: Linq To SQL

4
shouts

Shout it

How to Extract Filename from Path using SQL Functions

published 9 days, 7 hours, 12 minutes ago posted by

eralper 10 days, 8 hours, 25 minutes ago

How to Extract Filename from Path using SQL Functions In this sql tutorial, t-sql developers can find sql codes for extracting file name from fullpath of a file. No matter whether the file path is stored in a sql table column or full filepath is supplied as a sql variable or sql string parameter, sql developers can use either sql functions to parse file name or use sql string functions in order to extract file name. (more)

category: SQL | clicked: 23 | comment | | source: www.kodyaz.com

3
shouts

Shout it

Sql Server Reporting services 2008 Tablix control

published 9 days, 7 hours, 12 minutes ago posted by

Praveen 10 days, 5 hours, 13 minutes ago

Sql Server Reporting services 2008 Tablix control

When working with Sql server 2008 reporting services I found a new control named Tablix. [Of course there are plenty of new features] This is a mix of both Table and a Matrix. The main and great advantage of it is when we drag a table or matrix to the report body you can't find table or matrix any more. The report control automatically convert it to Tablix. Now, it's very easy to show the complex and grouping of data with this control. The interest thing in 2008 reporting services is, When I open report... (more)

category: SQL | clicked: 12 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server 2008, SSRS, Tablix

3
shouts

Shout it

Sql Express instance is not in the list of network servers

published 9 days, 7 hours, 12 minutes ago posted by

Praveen 10 days, 5 hours, 11 minutes ago

Sql Express instance is not in the list of network servers

Today, I have a requirement to work with SQL Server express. So, I setup a server with Sql server express installed and configured everything we needed. My team has 4 developers and everyone should access the sql server express to run the project. But, when they try to access the sql server express instance the server is not responding and always it results an error. When I open network servers, I found only the instances of my sql sever and in that list I didn't find the new sql server express I have se... (more)

category: SQL | clicked: 5 | comment | | source: praveenbattula.blogspot.com

tags: Sql Browser, SQL Express

7
shouts

Shout it

SQL SERVER – Rollback TRUNCATE Command in Transaction « Journey to SQL Authority with Pinal Dave

published 10 days, 8 hours, 42 minutes ago posted by

pinaldave 11 days, 2 hours, 46 minutes ago

SQL SERVER – Rollback TRUNCATE Command in Transaction « Journey to SQL Authority with Pinal Dave

This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not. If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not be retrieved from log file. TRUNCATE is DDL operation and it is not logged in log file. Update: (Based on comments of Paul Randal) Truncate IS a logged operation, it just doesn’t log removing the records, ... (more)

category: SQL | clicked: 24 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

6
shouts

Shout it

Tools SQL Server Tool List for Database Management, Development and Reporting

published 10 days, 8 hours, 42 minutes ago posted by

eralper 11 days, 10 hours, 25 minutes ago

Tools SQL Server Tool List for Database Management, Development and Reporting

SQL Server Tools - SQL Tool List for Database Management, Development and Reporting I want to group SQL Server tools according to their use and list tools for SQL Server by referencing the software information ... (more)

category: SQL | clicked: 29 | comment | | source: www.kodyaz.com

4
shouts

Shout it

SQL Server Backup Compression Software - SQL Backup Compression Tools

published 10 days, 8 hours, 42 minutes ago posted by

eralper 11 days, 13 hours, 35 minutes ago

SQL Server Backup Compression Software - SQL Backup Compression Tools After the release of Microsoft SQL Server 2008, sql database administrators (DBA's) and sql developers have acquired a new tool for SQL Se... (more)

category: SQL | clicked: 32 | comment | | source: www.kodyaz.com

tags: backup, backup compression, Compression, data compression, sql backup, SQL Server, SQL Server 2008, SQL Server 2008 Backup

4
shouts

Shout it

SQL Server Reports Integration with SharePoint 2007 | TechBubbles

published 10 days, 8 hours, 42 minutes ago posted by

kalyanms1 10 days, 23 hours, 55 minutes ago

SQL Server Reports Integration with SharePoint 2007 | TechBubbles

This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode. Determining which mode is ideal for Reports deployment Native Mode In this mode Reports, Data Sources and Report Models are all stored in Report Server Database. The published reports are executed solely in this environment. Share Point Integration Mode The following features are only availabl... (more)

category: SQL | clicked: 42 | comment | | source: www.techbubbles.com

tags: SQL Server Reporting Services

4
shouts

Shout it

LiteSpeed Backup SQL Server Backup Compression Tool

published 10 days, 8 hours, 42 minutes ago posted by

eralper 11 days, 13 hours, 31 minutes ago

LiteSpeed Backup SQL Server Backup Compression Tool In many companies SQL Server database administrators in IT departments prefer to use third-party SQL Server backup compression software and sql backup compr... (more)

category: SQL | clicked: 40 | comment | | source: www.kodyaz.com

tags: backup compression, data compression, LiteSpeed, sql backup, SQL Server, Tools

4
shouts

Shout it

SQL-Articles - Configure DB Mail Profile in SQL Agent for Automated Alerts

published 11 days, 11 hours, 44 minutes ago posted by

sqlarticles 12 days, 6 hours, 21 minutes ago

In the recent times I have seen so many people asking the same question in MSDN forums on how do I activate database mail for the use of SQL server agent alerts system. So I am taking a chance to document it by using screen shots which can help others. Normally what the newbie’s tending to do is, once they configured database mail ... (more)

category: SQL | clicked: 28 | 1 comment | | source: sql-articles.com

tags: Alerts, automatic alert, database mail, sql alert

7
shouts

Shout it

LightSpeed and LINQPad: the perfect partners

published 11 days, 11 hours, 44 minutes ago posted by

traskjd 13 days, 20 hours, 53 minutes ago

LightSpeed and LINQPad: the perfect partners

Today Mindscape released a LINQPad driver for LightSpeed 3.0. This extends LINQPad and allows developers to run LINQ Queries against LightSpeed models which, in turn, allows querying against SQL Server, Oracle, PostgreSQL, Amazon's SimpleDB, MySQL, SQLite, VistaDB, SQL Azure and DB2! (more)

category: SQL | clicked: 49 | 1 comment | | source: www.mindscape.co.nz

tags: LightSpeed, LinqPad, Oracle, PostgreSQL, SimpleDB, SQL Azure

5
shouts

Shout it

Autogenerated SQL constraint names - why to avoid them

published 19 days, 4 hours, 35 minutes ago posted by

AdaTheDev 20 days, 1 hour, 25 minutes ago

Autogenerated SQL constraint names - why to avoid them

Autogenerated constraint names in SQL Server - are they convenient, or are they a hindrance? For me, they are a hindrance. Why should I care that SQL Server autogenerates a constraint name when I don't explicitly specify one? This article explains reasons why you should specify a name yourself for each constraint. (more)

category: SQL | clicked: 3 | comment | | source: www.adathedev.co.uk

tags: Best Practise, constraints, SQLServer

5
shouts

Shout it

SQL Server Programming Fundamentals Tutorial

published 20 days, 3 hours, 38 minutes ago posted by

BlackWasp 21 days, 4 minutes ago

SQL Server Programming Fundamentals Tutorial

A 60-part series of articles exploring the fundamentals of programming using Microsoft SQL Server. The tutorial includes explanation of SQL Server and relational database concepts, the creation of databases and the Transact-SQL query language. (more)

category: SQL | clicked: 42 | comment | | source: www.blackwasp.co.uk

tags: MSSQL, SQLServer, TSQL

5
shouts

Shout it

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

published 20 days, 17 hours, 16 minutes ago posted by

AdaTheDev 22 days, 5 hours, 22 minutes ago

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

If you ever want to bulk load data into an SQL Server database as quickly as possible, the SqlBulkCopy class is your friend (in the System.Data.SqlClient namespace). Since being introduced in .NET 2.0, it has provided an extremely efficient way to bulk load data into SQL Server, and is one the classes that I see as a "must know about". A usual scenario is where you want to dump some data into the database to then do some processing on. Or you want to temporarily load some data in to then query to get som... (more)

category: SQL | clicked: 13 | comment | | source: www.adathedev.co.uk

tags: ADO.NET, Performance, SQLBulkCopy, SQLServer, SQL-Server

3
shouts

Shout it

Log Parser usage | TechBubbles

published 20 days, 17 hours, 16 minutes ago posted by

kalyanms1 23 days, 7 hours, 35 minutes ago

Log parser is a free tool from Microsoft where developers and support technicians can use to parse the IIS logs, Event Logs and Active Directory logs. This tool helps the developers to find the root cause for the site related issues. This post explains common commands that we use to look for specific information in IIS logs. The tool can be downloaded from here The default location for IIS logs is %windir%\System32\LogFiles\W3SVC (more)

category: SQL | clicked: 8 | comment | | source: www.techbubbles.com

7
shouts

Shout it

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

published 25 days, 9 hours, 10 minutes ago posted by

pinaldave 25 days, 14 hours, 43 minutes ago

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)

category: SQL | clicked: 62 | comment | | source: blog.sqlauthority.com

tags: Database, pinaldave, SQL, SQLAuthority, SQLServer

5
shouts

Shout it

SQL Server 2008 Data Types and Entity Framework 4 : Don't Be Iffy

published 28 days, 10 hours, 7 minutes ago posted by

https://me.yahoo.com/mosessaur#7fe0d 29 days, 2 hours, 45 minutes ago

SQL Server 2008 Data Types and Entity Framework 4 : Don't Be Iffy

Because I’ve had a lot of conversations about spatial data types lately, I thought I would create a SQL Server table that contained one of every type then bring it into an entity data model using the wizard to see what happens. This is in EF4. Here are screenshots of the table and the entity showing their property types. This way you can see what is and isn’t supported. The wizard excluded four fields it still doesn’t recognize at all.geographygeometryhierarchyidsql_variant If you focus on the entit... (more)

category: SQL | clicked: 50 | comment | | source: thedatafarm.com

tags: EF4, Entity Framework, entityframework4, SQLServer

7
shouts

Shout it

How to Execute SSIS Packages in C# ASP.NET - Part I

published 29 days, 11 hours, 53 minutes ago posted by

dotnetfunda 31 days, 13 hours, 55 minutes ago

How to Execute SSIS Packages in C# ASP.NET - Part I

In this s Article I am going to explain the technology that came with Sql 2005. This is SSIS which stands for Sql Server Integrated Services. Recently I was working on a project for a client with large sum of Data and there was a need to process the data on a certain time frame. There were lot of technologies available at my Disposal, but this kind of Functionality needed to be streamlined and optimised. Of all the Technologies, i have chosen SSIS. In this Article I will demonstrate on how to executing t... (more)

category: SQL | clicked: 40 | comment | | source: www.dotnetfunda.com

6
shouts

Shout it

SQL to XML with SSIS

published 29 days, 11 hours, 53 minutes ago posted by

http://derans.myopenid.com/ 31 days, 16 hours, 12 minutes ago

Have you ever had a vendor ask for XML instead of a quick CSV file? Well, if you’re using MSSQL 2005 or 2008, I’m sure you realized just how awesome they are when this request came through. I’m going to walk through exporting an XML file from SQL Server 2005 using SSIS ans SQL. (more)

category: SQL | clicked: 28 | comment | | source: derans.blogspot.com

7
shouts

Shout it

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

published 32 days, 11 hours, 45 minutes ago posted by

pinaldave 33 days, 10 hours, 3 minutes ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by... (more)

category: SQL | clicked: 43 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

Welcome!

Our Sponsors

The Lounge

SQL

Linq to Sql – How-to Separate the entities and the DataContext.

How to Extract Filename from Path using SQL Functions

Sql Server Reporting services 2008 Tablix control

Sql Express instance is not in the list of network servers

SQL SERVER – Rollback TRUNCATE Command in Transaction « Journey to SQL Authority with Pinal Dave

Tools SQL Server Tool List for Database Management, Development and Reporting

SQL Server Backup Compression Software - SQL Backup Compression Tools

SQL Server Reports Integration with SharePoint 2007 | TechBubbles

LiteSpeed Backup SQL Server Backup Compression Tool

SQL-Articles - Configure DB Mail Profile in SQL Agent for Automated Alerts

LightSpeed and LINQPad: the perfect partners

Autogenerated SQL constraint names - why to avoid them

SQL Server Programming Fundamentals Tutorial

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

Log Parser usage | TechBubbles

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

SQL Server 2008 Data Types and Entity Framework 4 : Don't Be Iffy

How to Execute SSIS Packages in C# ASP.NET - Part I

SQL to XML with SSIS

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

Open ID Login

Standard Login

Forgot Password?

Sign up