DotNetShoutout

chris4302

Name:	chris4302
Score:	9
Last Seen:	1211 days, 15 hours, 55 minutes ago
Member Since:	27 January, 2010

12
Shouts

Shout it

Configuring Data Compression – SQL Server 2008 – Part 4

published 1273 days, 11 minutes ago posted by

sqlarticles 1274 days, 14 hours, 48 minutes ago

In this article we are going to configure Data compression in SQL Server 2008. Configuring data compression is very easy with just an couple of steps. The steps are below Estimate the Compression Ratio (Optional) Configure Data Compression (more)

category: Data | clicked: 1 | 1 comment | | source: www.sql-articles.com

tags: data compression, sqlarticles, Compression

10
Shouts

Shout it

Main Differences between ASP.NET 3.5 and ASP.NET 4.0 - Part 1 - C#, ASP.Net, VB.Net

published 1273 days, 11 minutes ago posted by

https://me.yahoo.com/mosessaur#7fe0d 1274 days, 22 hours, 22 minutes ago

Main Differences between ASP.NET 3.5 and ASP.NET 4.0. (more)

category: Data | clicked: 3 | comment | | source: www.dotnetspark.com

tags: ASP.NET

10
Shouts

Shout it

TSQL Challenge 1

published 1273 days, 11 minutes ago posted by

vijipillai 1275 days, 5 hours, 55 minutes ago

This is a challenge to write a TSQL query that can run on SQL Server 2000, 2005 and 2008 and transforms the data in a table to a custom shape. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

9
Shouts

Shout it

Simple Insert,Update,View and Delete with LINQ-To-SQL

published 1272 days, 3 hours, 17 minutes ago posted by

http://jalpesh.blogspot.com/ 1273 days, 22 hours, 59 minutes ago

Today one of my friend asked me about simple insert,update and delete example with LINQ-To-SQL but at that time i was not having any simple example which will show the power of LINQ-To-SQL Example. So i have decided to create one simple example with LINQ-To-SQL and also decide to blog about it. Let's create a simple example which is very simple and also show basic step to use LINQ-To-SQL. First i have created a simple table called which have 4 fields like ProductId,Name,Description and Price. Like follow... (more)

category: Data | clicked: 0 | 1 comment | | source: jalpesh.blogspot.com

10
Shouts

Shout it

SQL Server Service accounts

published 1272 days, 3 hours, 17 minutes ago posted by

sqlarticles 1273 days, 10 hours, 29 minutes ago

Most entry level DBAs still have the confusion on what is a service account and which is the best to be used and when. This article will take you through that. Depending on the selection that you made while installing SQL Server, you will have the services installed in your server. (more)

category: Data | clicked: 1 | 1 comment | | source: www.sql-articles.com

tags: SQL Server, sqlarticles, service account

11
Shouts

Shout it

Meta-Me : Tip 45 – How to swap EF metadata at runtime.

published 1271 days, 55 minutes ago posted by

https://me.yahoo.com/mosessaur#7fe0d 1273 days, 1 hour, 53 minutes ago

Tip 45 – How to swap EF metadata at runtime. Background By default the Entity Framework embeds its metadata inside your assembly as a resource, and put a connection string in the App or Web Config references those resourses something like this (more)

category: Data | clicked: 1 | 1 comment | | source: blogs.msdn.com

tags: Metadata, EF 3.5, Entity Framework, EF4, EF 4.0, entityframework, Tips

12
Shouts

Shout it

SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave

published 1269 days, 10 hours, 49 minutes ago posted by

pinaldave 1270 days, 16 hours ago

As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at https://sql.azure.com/ Login using your Live ID Type in invitation code received from Microsoft for CTP. You can request one for your self here. Accept the TOU. Once logged it you will have to create server username and password. ... (more)

category: Data | clicked: 0 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

12
Shouts

Shout it

Dynamic Search Objects Part 6—the Search Service « Have Code, Will Travel

published 1268 days, 10 hours, 16 minutes ago posted by

psandler 1270 days, 22 hours, 28 minutes ago

If you’ve read this series up to this point, you pretty much have everything you need to implement dynamic queries in your own application. Just a few notes to wrap up the series and I will get on to other topics.Creating a Search Service Facade Depending on your requirements, it may be perfectly reasonable to create a tight coupling b... (more)

category: Data | clicked: 1 | comment | | source: psandler.wordpress.com

tags: LLBLGen SQL "Dynamic SQL"

14
Shouts

Shout it

IP Address Blocking or Restriction in SQL Server

published 1267 days, 4 hours, 41 minutes ago posted by

sqlarticles 1269 days, 13 hours, 44 minutes ago

I have seen some questions in forums asking for the answer “is it possible to block connections to SQL Server based on IP address”. As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more. * Firewall * IPSec * RRAS IP Filter (more)

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

tags: Administration, ip blocking

11
Shouts

Shout it

Database Articles - SQL Server and MySQL

published 1265 days, 22 hours, 22 minutes ago posted by

jshah1982 1267 days, 5 hours, 29 minutes ago

Blog URL: http://sqldbpool.wordpress.com/ You can find the articles related to SQL Server Architecture, Inner Process, Script, Interview Questions and more from this blog. (more)

category: Data | clicked: 1 | 1 comment | | source: sqldbpool.wordpress.com

8
Shouts

Shout it

Writing Unit Tests for Data Access Code « Have Code, Will Travel

published 1263 days, 2 hours, 14 minutes ago posted by

psandler 1264 days, 22 hours, 35 minutes ago

Had a question today from a developer from another software project within my company: How do I begin and rollback database transactions from a unit test? My short answer . . . You don’t. . . . led to a pointed follow-up question . . . So how do I write unit tests for my data access code? . . . which led to a somewhat lengthy discussion. It’s an i... (more)

category: Data | clicked: 5 | 1 comment | | source: psandler.wordpress.com

tags: SQL transaction database DAL TDD

9
Shouts

Shout it

Database Standards and Conventions « Have Code, Will Travel

published 1261 days, 12 hours, 25 minutes ago posted by

psandler 1261 days, 21 hours, 15 minutes ago

I was asked recently to write up a basic set of database standards and methodologies we would be using for an upcoming project. I tend to use the same standards on every project that I manage, and I am usually the final authority on determining our approach, so there usually isn’t a lot of discussion around this topic. However, in this case the client ... (more)

category: Data | clicked: 2 | comment | | source: psandler.wordpress.com

tags: SQL data modeling best practices standards rant

10
Shouts

Shout it

Mindscape LightSpeed 3 domain modeling and persistence framework

published 1256 days, 8 hours, 12 minutes ago posted by

http://vistadb.myopenid.com/ 1257 days, 21 hours, 2 minutes ago

Mindscape has announced a new version of their dot net ORM tool named Mindscape LightSpeed 3. Version 3 includes support for VistaDB 4 and a lot of other new features. Priced at only $199 per developer (source is available for an extra fee) LightSpeed is a very cost effective tool to add to any developers tool belt. There is also a free version available for databases with less than eight tables if you just want to take the product for a test drive. We recently spoke with John-Daniel Trask of Minds... (more)

category: Data | clicked: 0 | comment | | source: www.vistadb.net

tags: VistaDB, Visual Studio, Database, LightSpeed, ORM

7
Shouts

Shout it

VistaDB 4.1 Announcement with Microsoft Sync Framework Support

published 1256 days, 8 hours, 12 minutes ago posted by

http://vistadb.myopenid.com/ 1256 days, 23 hours, 8 minutes ago

We are finally ready to unveil some of the things we have been hard at work on since the release of VistaDB 4.0. One of the largest announcements is that we are going to support two way sync through the Microsoft Sync Framework ( Version 2 ). Sync has been a huge source of time wasted for us in the past through Sync 1, but it finally appears Microsoft has stabilized the API in Version 2 and is shipping it with Visual Studio 2010. Two Tier Sync using Sync Framework V2 (more)

category: Data | clicked: 17 | comment | | source: www.vistadb.net

tags: VistaDB, SQL, Sync Framework 2.0

11
Shouts

Shout it

SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave

published 1255 days, 9 hours, 29 minutes ago posted by

pinaldave 1257 days, 1 hour, 27 minutes ago

Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by suggesting following: Temp Table and Table Variable — both are created in TempDB and not in memory. Let us prove this concept by running the following T-SQL script. /* Check the difference between Temp Table... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

11
Shouts

Shout it

SQL Server - Working with IDENTITY SEEDs | syntaxhelp.com

published 1254 days, 10 hours, 43 minutes ago posted by

anilnairind 1256 days, 2 hours, 20 minutes ago

SQL ServerSQL AzureSQLCMDSQL Server CEAdding DatesCreating and Using a Number TableLinked ServerSQL Server - Aggrigration of strings using TSQLSQL Server - IDENTITYSQL Server - Working with IDENTITY INCREMENT propertySQL Server - Working with IDENTITY SEEDsSQL Server - Working with IDENTITY related DMVsSQL Server - MERGE ExampleSQL Server - Reading information from an XML document using OPENXMLSQL Server - User Defined Table TypesSQL Server - Using Row ConstructorsSQL Server - Using the PIVOT operatorSQL... (more)

category: Data | clicked: 0 | comment | | source: syntaxhelp.com

7
Shouts

Shout it

Web 2.0 | Reading and Writing BLOB Data to MS SQL or Oracle Database

published 1253 days, 9 hours, 41 minutes ago posted by

farooqkaiser 1254 days, 1 hour, 17 minutes ago

In this article, i will examine how to store and retrieve binary files such as image or PDF into MS SQL or Oracle database. Reading a File into a Byte Array 1:byte[] mbarrImg = null; 2:using (FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.Read, FileShare.Read)) 3: { 4: mbarrImg = newbyte[fs.Length]; 5:int iBytesRead = fs.Read(m_barrImg, 0, (int)fs.Length); 6: fs.Close(); 7: } Saving BLOB data from a file to Oracl... (more)

category: Data | clicked: 2 | 1 comment | | source: www.fairnet.com

tags: SQL Server, .NET, C#, Oracle

10
Shouts

Shout it

SQL-Articles - Monitoring Replication using Scripts(Version 1.0)

published 1251 days, 6 hours, 10 minutes ago posted by

sqlarticles 1253 days, 11 hours, 50 minutes ago

This script can be used to monitor replication using scripts instead of logging into the server and using replication monitor. It gives information on Transactional replication status. (more)

category: Data | clicked: 0 | comment | | source: www.sql-articles.com

tags: replication, scripts, sqlarticles

10
Shouts

Shout it

Adding article to existing publication without generating a full snapshot

published 1251 days, 6 hours, 10 minutes ago posted by

sqlarticles 1253 days, 11 hours, 51 minutes ago

This SP can be used to add articles to the existing publication without starting snapshot for all the tables. When Snapshot is started it will create snapshot only for the newly added article to the publication (more)

category: Data | clicked: 0 | 1 comment | | source: www.sql-articles.com

tags: replication, scripts, sqlarticles

5
Shouts

Shout it

Refresh intellisense local cache in Sql Server 2008

published 1223 days, 9 hours, 14 minutes ago posted by

Praveen 1223 days, 14 hours, 14 minutes ago

Everyone knows that Sql server 2008 has an excellent feature for supporting the intellisense. This will surely fasten the development. Last week, I have created 3 tables in my Sql server 2008 and when I try to write the stored procedure based on those tables, surprisingly they weren't shown in the intellisense any more. I thought initially it's a bug in Sql Server 2008. Lately after done some research and found that we need to refresh the cache for intellisense to shown up everything correct. Please find... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server 2008, Intellisense

Welcome!

chris4302

Configuring Data Compression – SQL Server 2008 – Part 4

Main Differences between ASP.NET 3.5 and ASP.NET 4.0 - Part 1 - C#, ASP.Net, VB.Net

TSQL Challenge 1

Simple Insert,Update,View and Delete with LINQ-To-SQL

SQL Server Service accounts

Meta-Me : Tip 45 – How to swap EF metadata at runtime.

SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave

Dynamic Search Objects Part 6—the Search Service « Have Code, Will Travel

IP Address Blocking or Restriction in SQL Server

Database Articles - SQL Server and MySQL

Writing Unit Tests for Data Access Code « Have Code, Will Travel

Database Standards and Conventions « Have Code, Will Travel

Mindscape LightSpeed 3 domain modeling and persistence framework

VistaDB 4.1 Announcement with Microsoft Sync Framework Support

SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave

SQL Server - Working with IDENTITY SEEDs | syntaxhelp.com

Web 2.0 | Reading and Writing BLOB Data to MS SQL or Oracle Database

SQL-Articles - Monitoring Replication using Scripts(Version 1.0)

Adding article to existing publication without generating a full snapshot

Refresh intellisense local cache in Sql Server 2008

Open ID Login

Standard Login

Forgot Password?

Sign up