In this article we will see how to create Silverlight application that follows MVVM Web Application Pattern and Performing CRUD operations in Silverlight Data Grid.
Tapas Pal shows you how to encrypt your SQL Server database for a pre-existing, business critical web application using Transparent Data Encryption (TDE), a new full database encryption technique introduced in SQL Server 2008.
Among the big news this week in green data center management: Equinix was granted LEED certification for its 2009 retrofit of its Silicon Valley SV2 International Business Exchange facility, Neuwing Energy Ventures announced it successfully registered the first voluntary Energy Efficiency Certificates in the newly launched APX North American Renewables Registry, and more.
The requirements for setting up Oracle as a data source for SQL Server include some obstacles and one major showstopper. Read on to learn a work-a-round that allows you to continue the setup.
Legal fees are the main reason the average cost of a data breach costs American companies more than their counterparts in Australia and Europe, says Ponemon Institute.
Occasionally, when deploying a database, you need to copy data out to file from all the tables in a database. Phil Factor shows how to do it, and illustrates its use by copying an entire database from one server to another.
SQL Backup Pro wins Gold Community Choice AwardFind out why the SQL Server Community voted SQL Backup Pro 'Best Backup and Recovery Product 2012'. Get faster, smaller, fully verified backups. Download a free trial now.
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will be a REAL boost to any DBA lucky enough
to use it." Jonathan Allen.
Download a free trial now.
To deliver our services, Google has had to develop sophisticated internal tools to process data more efficiently. We know that some of these tools could be useful to...
From stolen devices and phishing attacks, to buggy apps and human blunders, 2009 was a banner year for data breaches. Here are 10 from which we can learn a lot.
[posted by Suzanne Selhorn, Technical Writer on the MDS team] Some new self-paced training is now available on the Microsoft Download Center. To take advantage of this training, you should have a working installation of MDS with sample data already loaded. 01 Introduction http://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/01 Introduction.pdf This lesson provides an overview of MDS. 02 MDS Environment http://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/02...(read more)
Even though the Import and Export Wizard, incorporated into the SQL Server 2008 platform, greatly simplifies the creation of SQL Server Integration Services packages, it has its limitations. This article points out the primary challenges associated with using it to copy data between SQL Server 2008 and Excel and presents methods of addressing these challenges.
This article provides a short PowerShell script to extrace data from a database using PowerShell.
24% of devs don’t use database source control – make sure you aren’t one of themVersion control is standard for application code, but databases haven’t caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out…
Quite often, the database developer or tester is faced with having to load data into a newly created database. What could be simpler? Quite a lot of things, it seems.
SQL Backup Pro wins Gold Community Choice AwardFind out why the SQL Server Community voted SQL Backup Pro 'Best Backup and Recovery Product 2012'. Get faster, smaller, fully verified backups. Download a free trial now.
Besides generating a chuckle or two, a manure-powered data center may be the ultimate in sustainable energy for both developed and developing countries. HP Labs presented the concept at the ASME International Conference on Sustainability last week.
Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
Display, edit and save large data sets in Silverlight using WCF based services and customized DataGrids...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 Silverlight. Take a look: here.
Overview
SQL Server 2008 introduced a new category of datatypes known as
spatial datatypes which stores spatial information. The new spatial datatypes are
geography and geometry. SQL Server Management Studio comes with
good good support
for these spatial data ... [Read Full Article]
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.
FREE eBook – "45 Database Performance Tips for Developers"Improve your database performance with 45 tips from SQL Server MVPs and industry experts. Get the eBook here.
One simple step you can take to protect your data or small business network is to prevent employees from using USB Flash drives and CD/DVD drives on company PCs. We'll show you how.
One simple step you can take to protect your data or small business network is to prevent employees from using USB Flash drives and CD/DVD drives on company PCs. We'll show you how.
One simple step you can take to protect your data or small business network is to prevent employees from using USB Flash drives and CD/DVD drives on company PCs. We'll show you how.
Here is an article I wrote for MSDN that introduces us to the GetClusterCharacteristics stored procedure in SQL Server Data Mining. It gives us an insight into how the sequences within clusters are derived when using the Sequence Clustering algorithm. Link to article
I'm in the process of learning Scala and I came across a scenario today where I need to map multiple functions over a single piece of data and wondered if there was a formal name for this. It sort of feels like the inverse of map.
I'm not sure this is the correct way of expressing it, but this is what I did:
dmap(x: Object, fns: List[Function]) = fns.map(_(x))
Is there a built in way to do something similar? Is there a formal name for this function?
Tapas Pal shows you how to encrypt your SQL Server database for a pre-existing, business critical web application using Transparent Data Encryption (TDE), a new full database encryption technique introduced in SQL Server 2008.