SQL Server 2008 CTP Released
Microsoft announced release of the first community technology preview of SQL Server 2008 at the Microsoft TechEd Conference in Orlando....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including......
SQL Server 2008 June CTP has been annouced at TechEd 2007
At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! See here for the official scoop and register here!
What does thi......
SQL Server 2008 June CTP has been annouced at TechEd 2007.
At today's TechEd 2007 in Orlando, we have annouced SQL Server 2008's, formerly known as Katmai, first community tech preview (CTP). Unlike SQL Server 2005, where we took over 5 years, SQL Server 2008 will be delivered in less than 3! https://connect.microsoft.com/SQLServer/content/conten......
Four New " "Working with Data in ASP.NET 2.0" " Tutorials Available - Caching
My Working with Data in ASP.NET 2.0 tutorial series has been updated with four new tutorials on caching data. Caching is a technique that has long been used by computer scientists to improve an application's performance. ASP.NET 1.x introduced a powerful caching API that ASP.NET 2.0 has built upon.......
Skelta SharePoint Accelerator 2007 selected as Best of Tech-ED 2007 Awards Finalist
Skeltas SharePoint Accelerator is selected as a finalist for the Best of TechEd 2007 Awards in the Office Systems category by Penton Medias Windows IT Pro, SQL Server Magazine and Office & SharePoint Pro.com...Did you know that DotNetSlackers also publishes .net articles written by top known .net A......
Daily WTF - Deleting SQL Data (or Properly Formatting SQL)
We've been having an issue with one of our database tables' mysteriously deleting data at random. We could have *swore* it was some sort of SQL intrusion or code bug. We leaned towards SQL intrusion because this database has been in use for quite some time. However, that was not the case. A......
DTS in SQL 2005 - Good News and Bad News
DTS has always worried me.
Unfortunately, I have 331 reasons to worry:
PS > gci -r -i *.dts | group Extension
Count Name
----- ---- . . .
331 .dts
Five years ago, ADO.NET didn't have a bulkload API, and DTS seemed like the best tool for moving and transforming
millions of rec......
mojoPortal Reviewed in aspnetNow April 2007
Anand Narayanaswamy, Microsoft MVP & Author of Community Server Quickly, has published a review of MojoPortal in April 2007 issue of aspnetNOW e-newsletter, which is the free e-companion to aspnetPRO Magazine.
Read the article here:
http://www.aspnetpro.com/Productreviews/2007/04/asp200704an_p/asp......
Select a random row with SQL Server 2005
Life can be so easy with SQL Server 2005:SELECT TOP (1) Field FROM Table ORDER BY NEWID();This works in MySQL, too, a bit different though:SELECT Field FROM Table ORDER BY RAND() LIMIT 1;Comes in quite handy sometimes!...
...
SQL Server 2005 SP2 Re-release and post fixes
Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL Server 2005 SP2 and fixes posted later. This is a must read for anyone deploying SQL Server 2005 SP2 to understand the various hotfixes, GDRs and procedures. Please visit his link for more details. ......
Reading and Writing Files in SQL Server using T-SQL
SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite up to the task at hand especially when dealing with large strings or relatively unstructured data. Phil Factor provides some T-SQL stored procedures, based on use of the ......
T-SQL Quiz - Dealing With Trends
Im not one to post a lot of quizzes on my blog. Lets face it, while we may create altruistic reasons for posting quizzes such as:
Its an interesting problem I thought up
Its an interesting bug I ran into
we all know the real reasons for posting a quiz.
It serves as blog filler.
......
How to Delete All the Stored Procedures in a SQL Server 2005 Database
I've been going through the learning curve with CodeSmith and the initial results are pretty interesting, especially with the free NetTiers template set. Man, does that generate a bunch of stored procs, entity and domain objects and controls! If you get used to the model, you are virtually going to......
Automate your Database Maintenance using SMO
The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations. In Part 1 of a three article series, Allen White shows how to automate the backup of all of your databases, using SQL ......
Filtering Custom Paged Results
The ASP.NET 2.0 data web controls - the GridView, DetailsView, and FormView - all provide built-in paging support that can
be enabled at the tick of a checkbox. Unfortunately, this built-in paging support is very inefficient when paging through
large amounts of data since it naively grabs all of t......
Programming SQL Server 2005 Reporting Services Slides and Samples
I just uploaded my slides and samples for my Programming SQL Server 2005 Reporting Services talk at Microsoft ASP.NET Connections last week in sunny Orlando.This talk focused on programming SSRS using:URL access.SSRS Web Service.SSRS Report Viewer controls.Custom Assemblies You can find t......
OUTPUT Clause in SQL Server 2005
In previous versions of T-SQL you had to use a trigger to retrieve data from inserted, updated or deleted rows in tables which wasn't very straightforward. SQL Server 2005 adds a new clause to T-SQL to simplify this task. OUTPUT is this clause. First suppose that I have a simple table l......
Enterprise Library 3.0
This post will be kind of late, but I know many that haven’t seen or heard abut the Enterprise Library, so if you all have some time over and want to try out something cool, then take a look at Enterprise Library 3.0, which have the following blocks and improvements:
New application blocks
......
SQL Server 2005 Performance Dashboard Reports
The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a......
Creating cross tab queries and pivot tables in SQL
For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to do it "on the fly". You can add it to your database and start cross tabbing immediately, without any further setup or changes to you SQL code....
...
Issue with SQL Server Restart when Installing SNMP
George Dougherty emailed me with an interesting problem that he and Tony
Sengphirom discovered.
A cursory google search didn't find anything, but we came across a pretty
big gotcha this morning with our production database server. We're running SQL
2000 on Windows 2003 R2 with SP2. I haven......
OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Please note that the examples uses DMVs that looks at m......
Pop Rivett and the Case of the Rogue SPIDs
A process in a complex database occasionally, and apparently randomly, manages to put table locks on vital tables. Several applications are brought to a complete halt. Armed with a T-SQL stored procedure, a violin and a keen investigative spirit, Pop Rivett tracks down the rogue SPIDs that are caus......
Transferring Data Using SqlBulkCopy Class
Transferring data from one source to another is a common practice in software development. This operation is preformed in many different scenarios which includes migration of the old system to the new system, backing up the data and collecting data from different publishers. ASP.NET 2.0 includes th......
April`s Toolbox Column Now Available Online
MyToolbox column in theApril 2007issue of MSDN Magazine is now avaiable online. TheApril issue examinesthree products:
WiXAware-a program for graphically creating and managing WiX installation files.
Apose.Slides for .NET- programmatically create and edit PowerPoint presentations.
Subversion- a ......
ERROR: 42601: a column definition list is only allowed for functions returning record
Since the postgres forums appear to be a little quite, I'll post my error here as well.
This error is in regards to the postgres .net npgsql driver and seemed to only occur when using stored procs.
The Error
The behavior I experienced happens when using stored procedures started out with me ......
ERROR: 42601: a column definition list is only allowed for functions returning record
Since the postgres forums appear to be a little quite, I'll post my error here as well.
This error is in regards to the postgres .net npgsql driver and seemed to only occur when using stored procs.
The Error
The behavior I experienced happens when using stored procedures started out with me ......
Building a multi-tier data-driven web application using the SqlDataSource control
This article explains how to use the SqlDataSource control to create a web application separating the presentation layer from the data access layer. No more SQL code in your presentation layer.
...
SQL Server and SODA
Over the past year, I've been discussing some of the various technologies found inside SQL Server 2005. Three of these technologies are CLR integration, HTTP endpoints, and Service Broker. (Articles on these topics were published, respectively, in the November 2005, March 2006, and November 2006 ed......
SqlServer Floating point
SqlServer seems to throw an error when using higher than e308 for e-309 it just makes the value = 0. Either way, this regexp seems to work for me. and allows for empty string as well. To negate the empty string pass through in asp.net just add a required field validator--if your already program asp......
FIX: Error message when you connect two SQL Server databases in a transaction scope in the .NET Framework 2.0: " "System.InvalidOperationException SqlConnection does not support parallel transactions" "
929246 ... FIX: Error message when you connect two SQL Server databases in a transaction scope in the .NET Framework 2.0: "System.InvalidOperationException SqlConnection does not support parallel transactions"This RSS feed provided by kbAlerz.com.Visit kbAlertz.com to
subscribe. It's 100% free a......
ASP.NET Caching: SQL Cache Dependency With SQL Server 2000
SQL cache dependencies are one of the most wonderful new features in ASP.NET 2.0, the ability to automatically invalidate a cached data object (such as a DataSet or Custom Data Type) when the related data is modified in the database. This feature is supported in both SQL Server 2005 and in SQL Serv......
Building a multi-tier data-driven web application using the SqlDataSource control.
This article explains how to use the SqlStoreDataSource control to create a web application separating the presentation layer from the data access layer. No more SQL code within your presentation layer....
...
Generate Scripts in Sql Management Studio
I frequently generate scripts for SQL 2000 and its not uncommon when I use SQL 2005 that I use a feature that doesnt work in Sql 2000, so the steps to do this are:
Run the Wizard
9 steps later: Generate
Fail
Completely start over with 9 previous Steps
Uhm, somethings n......
Sql Server 2005 Service Pack 2 Critical Patch
http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=enIf you were a good developer, you downloaded and installed SP2 the moment that it became available because all developers are good about having the latest and greatest. Well, looks like......
SQL Server Security Workbench Part 1
Robyn Page and Phil Factor present practical T-SQL techniques for controlling access to sensitive information within the database, and preventing malicious SQL injection attacks....
...
Writing to Word from SQL Server
Never a man to walk away from a challenge, Phil Factor set himself the task of automating the production of Word reports from SQL Server, armed only with OLE automation and a couple of stored procedures....
...
Using Symmetric Encryption in a SQL Server 2005 Database
As the attacks in which hackers use become more and more sophisticated, and the programs in which they attack become
increasingly complex, encryption is becoming the last line of defense in database management system (DBMS) security.
A previous article of ours, An Overview of Cryptographic System......
Every one wants Free ASP.NET host with MSSQL 2005 (Here u go)
Free lunch actually is here
http://www.freewindowshost.com/
Free plan (Text or image banner required)
1 Top Level domain ( www.yourname.com )
200 MB Diskspace
1 GB Monthly Transfer ( Bandwidth ......
SQL Server Error Handling Workbench
Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities....
...
SQL Server Security Cribsheet
If you've ever had brain meltdown trying to understand SQL Server users, roles, permissions, logins etc. then Robyn Page's security cribsheet might be just be your Panacea....
...
Bak2Basics: Learn T-SQL - FOR XML
So if you'd ask me one of the most under-used and useful features of TSQL, I'd have to say "FOR XML" queries. I don't quite understand why enough people don't use 'em, because they truly are very useful, so I figured, hey why not write up a blog post on what the heck t......
SQL Server 2005 SP2 has been Released
Looks like we have an update to SQL Server 2005, Service Pack 2 has not been released. Key features are Vista and Office 2007 compatability. Other items include Data-Mining, Reporting and Analysis Services, Data Compression, Management Services and Interoperability...(read more)...
...
SQL Server 2005 SP2 has been released to the web
Today SQL Server 2005 SP2 has become officially available for download. It will be available on DVDs or CDs in March.
Besides fixing lots of issues that have been reported, SP2 also enables several BI functionalities of Office 2007.
Decimal data can now be stored as variable length in the SQL Serv......
SQL Server 2005 SP2 has been released...
SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page. This service pack extends the functionality of SQL Server in many ways. The What's New document highlights the major changes in the Database Engine, Analysis Services, Integration Services ......
SQL Server 2005 SP2 RTM
Service Pack 2 for SQL Server 2005 has RTM-ed! Why do you read SQL related stuff on my blog? Well this service pack includes the long awaited Reporting Services web parts for SharePoint 2007 (WSS v3 and MOSS 2007). From the what's new page: You can integrate a report server instance with Windows Sh......
Passing lists to SQL Server 2005 with XML Parameters
Overview SQL Server 2005's XML capabilities make it a easier to pass lists to SQL Server procedures. Background I recently needed to write a stored procedure which took a list of ID's as a parameter. That's one of those things that seems like it would be really simple, but isn&#......
An Overview of Cryptographic Systems and Encrypting Database Data
As the attacks in which hackers use become more and more sophisticated, and the programs in which they attack become increasingly
complex, encryption is becoming the last line of defense in database management system (DBMS) security. Since Microsoft
announced their Trustworthy Computing security......
Repeating A Details Section Using Crystal Reports
This year I created a 1099 reporting module for our accounting system. One issue I came across occurred when I was pulling the information from Microsoft SQL into a Crystal Report. I couldn't find a nice, clean way to print two 1099s per page. Then it hit me. I could have two detailed sections.......
Beginning SQL Server Reporting Services Part 4
The long-awaited final installment of Steve Joubert's popular 4-part "from the ground up" guide to SQL Server 2005 Reporting Services. Here, he dissects the Report Definition Language and provides a practical demonstration on the use of Report Builder, an ad-hoc reporting tool that allows end users......