News in the Category:
SQL 
Total posts: 3844 | Sort by Views | Sort by Hits
Karl Seguin [MVP], December 5, 2008
Views: 121 | Hits 4
SOLID is a popular acronym that refers to a set of 5 important class design principles. I know developers get overloaded with the endless jargon that keep popping up, especially when it seems to do li...
Scott Cates WebLog, December 5, 2008
Views: 320 | Hits 3
December 9th Noon-5pm Architect Council | Cloud Computing and Impact on Architecture Details Below :: Must Register here to attend. December 10th 11-5 (plus an after party sponsored by GoDaddy)...
Journey to SQL Authority with Pinal Dave, December 4, 2008
Views: 537 | Hits 9
Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; i...
Journey to SQL Authority with Pinal Dave, December 3, 2008
Views: 880 | Hits 105
Recently I wrote article about SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial, I received couple of comment suggesting that I did not talk abou...
Simple Talk, December 2, 2008
Views: 297 | Hits 16
Thomas LaRock shows just how easy it is for a DBAs to monitor any aspect of the databases in their charge by using Operations Manager, just as long as they are prepared to spit on their hands and do s...
Journey to SQL Authority with Pinal Dave, December 2, 2008
Views: 646 | Hits 56
SQL SERVER 2008 RTM has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to ...
Simple Talk, December 1, 2008
Views: 203 | Hits 13
In SQL Server 2005 and 2008 the HashBytes function provides us with the ability to perform the mono-directional approach to encryption. The consideration of utilizing the HashBytes function in your da...
The Code Project Latest Articles, December 1, 2008
Views: 485 | Hits 38
SQL Mirroring made easy - setting up a mirror for a database...
DNN Creative Magazine for DotNetNuke, December 1, 2008
Views: 449 | Hits 4
This tutorial demonstrates a method for quickly adding large amounts of data into a DotNetNuke module. The module in this example is the core Documents module.
Throughout the tutorial we walk you thr...
Journey to SQL Authority with Pinal Dave, December 1, 2008
Views: 372 | Hits 10
In these times of economical slowdown, more and more IT professionals are concerned about their jobs and their qualifications. It is a common trend for developers to start looking for ways to update t...
Journey to SQL Authority with Pinal Dave, November 30, 2008
Views: 405 | Hits 34
Previously I wrote article about SQL SERVER - Interesting Observation about Order of Resultset without ORDER BY and I have received tremendous response from my readers by emails and comments. Readers ...
youve been HAACKED, November 28, 2008
Views: 408 | Hits 10
A Subtext user found a security flaw which opens up Subtext to potential XSS attacks via comment. This flaw was introduced in Subtext 2.0 by the feature which converts URLs to anchor tags. If you are ...
Journey to SQL Authority with Pinal Dave, November 27, 2008
Views: 378 | Hits 11
SQL Server 2008 Report Definition Language SpecificationThe goal of Report Definition Language (RDL) is to promote the interoperability of commercial reporting products by defining a common schema tha...
Steven Smith, November 25, 2008
Views: 384 | Hits 20
Last week, we launched SQLFeeds.com, a community-moderated site focused on providing SQL developers and DBAs with high signal-to-noise SQL content. If you have a favorite source of SQL wisdom, p...
Pablo M. Cibraro (aka Cibrax), November 25, 2008
Views: 357 | Hits 14
A durable service in WCF is by a definition a service that can persist all its internal state across calls in some durable storage. For every operation, the service state is retrieved from the storage...
Journey to SQL Authority with Pinal Dave, November 25, 2008
Views: 324 | Hits 1
It is time again to announce SQL Hour - SQL Server User Group Meeting for November 2008. This time it is going to be one really interesting event. Our User Group is growing and getting more interestin...
ASP.NET Announcements, November 25, 2008
Views: 359 | Hits 39
For only start from $4.99/month youll get another great
hosting packages which features :
-
- Crystal Report 2008 Hosting
- &nb...
Julia Lerman Blog - Dont Be Iffy..., November 25, 2008
Views: 343 | Hits 6
A reader of the Rough
Cuts edition of my book, with only 9 chapters out of 23 available so far, was
not able to find the database scripts for the book's sample databases and because
of this, to my gr...
Journey to SQL Authority with Pinal Dave, November 24, 2008
Views: 380 | Hits 31
Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers.I ran following two queries and found that I am getting different result-set. When I...
ASPAlliance.com - The #1 ASP.NET Community, November 24, 2008
Views: 723 | Hits 77
In this article, Steven demonstrates the steps required to configure forms authentication in SharePoint using SQL Server as a database engine. He begins explaining the idea behind the article and then...
Journey to SQL Authority with Pinal Dave, November 23, 2008
Views: 1,054 | Hits 68
The following sample databases are currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:The AdventureWorks OLTP database supports standard online transaction processing scen...
Journey to SQL Authority with Pinal Dave, November 22, 2008
Views: 453 | Hits 14
I love active participation from my readers. Just a day ago I wrote article about SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung ...
Journey to SQL Authority with Pinal Dave, November 21, 2008
Views: 441 | Hits 12
Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying sec...
Wallace B. McClure, November 20, 2008
Views: 427 | Hits 21
Ok, so Microsoft's Team Foundation Server has been available for
several years. We've stuck with a couple of open source source control
/ project management apps. John keeps moving things ...
Journey to SQL Authority with Pinal Dave, November 20, 2008
Views: 472 | Hits 24
SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however,...
eXtensible mind, November 19, 2008
Views: 390 | Hits 5
While attempting to install SQL Server x64 I got a number of errors, so I ended up uninstalling all components I could find in the control panel, and reinstalling x32. Now it was time for SP2, I ende...
FTPOnline ASP.NET Channel, November 19, 2008
Views: 375 | Hits 9
Microsoft today previewed the ability to centrally manage applications and resources in the planned upgrade of SQL Server, code-named "Kilimanjaro."...
Scott on Writing, November 17, 2008
Views: 927 | Hits 16
One of my clients has a data-driven Software as a Service (SaaS) web application that is used by a dozen different customers. In particular, this client of mine has a web application that's used by va...
Guy Barrettes WebLog, November 17, 2008
Views: 430 | Hits 5
http://www.dotnetmontreal.com
Sujet: SQL Server 2008 New Features for DevelopersConfrencier: Michelle GutzaitNote: cette prsentation sera en anglais
Microsoft recently released a new version of its...
Williams .Net Zone, November 17, 2008
Views: 504 | Hits 52
...And in the same reply. I racked my brain for a few days trying to figure out a way to return the count of a query in the same reply with the results for my client paging control. I started with mak...
Brian Desmonds Blog, November 16, 2008
Views: 530 | Hits 40
Amazon announced the ability to run Windows virtual machines on their cloud computing platform, EC2, a few weeks ago. I had the opportunity to play with the technology for a few weeks and I was really...
the telerik blogs, November 15, 2008
Views: 1,055 | Hits
Tonight I ran into the following error message when using a freshly installed version of SQL Server 2008 in a new project.
Saving changes is not permitted. The changes you have made require the foll...
Simple Talk, November 15, 2008
Views: 428 | Hits 17
In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-b...
MSDN: ASP.NET, November 13, 2008
Views: 202 | Hits
Join MSDN Events for the latest tips, tools, and technical information you need to build powerful applications and engaging user experiences using SQL Server 2008, Visual Studio Tools for Office, and ...
Journey to SQL Authority with Pinal Dave, November 13, 2008
Views: 338 | Hits 3
Yesterday I wrote about SQLAuthority News - Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few ...
Scott on Writing, November 13, 2008
Views: 450 | Hits 26
Feel free to print out a copy of these commandments and tape them to your coworker's monitor.
You shall check in early and check in often. You anger your coworkers when you check out a file and insis...
Journey to SQL Authority with Pinal Dave, November 12, 2008
Views: 300 | Hits 5
The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:Which application, database or login is using the ...
DevX: Latest XML Articles, November 11, 2008
Views: 402 | Hits 8
Passing arrays as arguments to stored procedures is not currently possible in SQL Server, but you can use XML to accomplish this....
Marquee de Sells: Chriss insight outlet, November 11, 2008
Views: 361 | Hits 13
Roger Alsing has posted a discussion of how Intellipad's support for MGrammar development makes writing DSLs easier but showing you what parsers and how as you update the input file and the grammar fi...
K. Scott Allen, November 11, 2008
Views: 419 | Hits 35
Tim Mallalieu, PM of LINQ to SQL and LINQ to Entities, recently announced: as of .NET 4.0 the Entity Framework will be our recommended data access solution for LINQ to relational scenarios. Tim later...
Journey to SQL Authority with Pinal Dave, November 11, 2008
Views: 764 | Hits 51
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be execute...
Laurent Duveau, November 10, 2008
Views: 743 | Hits 88
Since Visual Studio 2008 SP1 you may have noticed 2 projects template for dynamic data: So what is the difference ? Dynamic Data Web Site / Dynamic Data Web Application: Uses a LINQ to S...
Journey to SQL Authority with Pinal Dave, November 10, 2008
Views: 655 | Hits 41
Today we will see quick script which will check integrity of all the database of SQL Server.EXEC sp_msforeachdb ‘DBCCCHECKDB(”?”)’ Above script will return you lots of messages in resultset. If there ...
The Code Project Latest Articles, November 9, 2008
Views: 484 | Hits 36
A class for unit testing ASP.NET data caching when using SQL Server...
Journey to SQL Authority with Pinal Dave, November 9, 2008
Views: 494 | Hits 9
SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference.Getting Started: New and Updated Topics (31 October 2008)Analysis Services - Multidimensi...
The Moth, November 8, 2008
Views: 98 | Hits
The question of "How do I try/show the parallel bits in VS2010 outside of the VPC?" or variants of that keeps appearing in my inbox. That is because of Virtual PC's limitation to only run one core, ...
The Moth, November 8, 2008
Views: 491 | Hits 11
The question of "How do I try/show the parallel bits in VS2010 outside of the VPC?" or variants of that keeps appearing in my inbox. That is because of Virtual PC's limitation to only run one core, ...
Julia Lerman Blog - Dont Be Iffy..., November 8, 2008
Views: 520 | Hits 72
Ever the avoider of controversy, I've kept my head down for the past week so I could
finish getting my book into the hands of the copy editor. Of course, now I'm preparing
for next week's presentatio...
Journey to SQL Authority with Pinal Dave, November 8, 2008
Views: 983 | Hits 39
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005.Download Mi...
The Moth, November 7, 2008
Views: 99 | Hits
The question of "How do I try/show the parallel bits in VS2010 outside of the VPC?" or variants of that keeps appearing in my inbox. That is because of Virtual PC's limitation to only run one core, ...