NEW! Free Trial of Total
Data Quality for SQL Server 2008
Learn about the full range of data transformation and cleansing
functionality available in the Total Data Quality Integration Toolkit
for SSIS. View demonstration videos on Profiling, Parsing, Cleansing,
Matching, and Monitoring – then request your free trial of the most
affordable, single platform solution for your data quality and MDM
initiatives.
Learn more now
|
by Brian Moran,
bmoran@solidq.com
Microsoft published the SQL Server 2008 System Views Map
a few weeks ago, and it’s available for download from www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en.
Kudos to Boris Baryshnikov from Microsoft for pulling the poster
together with support from SQL Server MVP Ron Talmage. These posters are
perennial favorites within the SQL Server community, so I’m sure
you’ll want to grab a copy. You can download the file in PDF or XPS
format from Microsoft, although you’ll be stuck with a lot of taped
together pages if you’re want the poster to grace your wall for easy
reference. You can’t order a printed version directly from Microsoft,
but Kinko’s or a commercial printer can get you a copy suitable for
hanging on your wall. Also, SQL Server Magazine told me it’s working
on making print copies of the System Views Map available through
Left-Brain.com, Penton Media’s new storefront. I don’t know when the
poster will be orderable, but I’ll be sure to let you know once it’s
available on Left-Brain.com. I know many of you are still running SQL
Server 2005, and there’s a system table poster available for that
version as well at www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en.
While we’re on the topic of documentation, I would also like to point
out that a new version of SQL Server 2008 Books Online (BOL) is
now available at www.microsoft.com/downloads/details.aspx?familyid=765433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en.
Click
here to read the rest of SQL Server 2008 System Views Map
Availability and More
|
Business
Process Automation: Managing Cost in Your Enterprise
This ebook gives you a solid
foundation on the basics of business process automation, a look at
the way BPA tools work, and how they can be utilized to benefit both IT
and overall business efficiencies. You'll learn where BPA can fit into
your existing business process model, how BPA differs from other basic
scripting and scheduling techniques, and what benefits your business
model can derive from implementing a BPA solution.
Step-by-step, the process necessary to implement and deploy a BPA
solution, providing valuable tips and tricks that can be applied to your
own computing environment and that can be applied to make your business
processes more efficient.
Learn
more!
|
Are you planning to attend DevConnections in
March?
Go to the SQL Server Magazine home page (www.sqlmag.com) and submit your vote
for:
- Yes, my company is paying for my travel and conference expenses
- Yes, but I have to pay for my travel and conference expenses
- I haven't decided yet
- I'm still waiting to hear if my company will pay for my travel and
conference expenses
- No, my organization has cut the travel budget because of the
economy
- No, I never go to DevConnections
- What's DevConnections?
SQL Server Freebies at Microsoft's CodePlex Site
by Michael Otey
Microsoft’s AdventureWorks series of sample SQL Server databases is
now available at its open-source website CodePlex—which is where you
can find these 7 great downloads, plus more tools and utilities.
http://www.sqlmag.com/Article/ArticleID/101222/sql_server_101222.html
SQL Data Generator
by Michael K. Campbell
For generating sample and testing data for SQL server databases, this
product will win you over as quickly as it produces data.
http://www.sqlmag.com/Article/ArticleID/100517/sql_server_100517.html
What is the difference between bulk insert and
BCP?
Find out here
Can stabos execute a SQL Server report in SQL Server Reporting
Services through a SQL Server Integration Services (SSIS) package?
See what your peers think
Brian Reinholz,
products@sqlmag.com
If your organization is like most, you've probably
either been hit by layoffs and benefit cuts, or if nothing else a few
"cost savings initiatives." Whether IT has taken a direct hit or been
battered indirectly by the strain put on the rest of the company, you're
most likely now expected to do more with less, including things you've
never had formal training for.
One of the most common cases now is being asked to implement, customize,
and train an entire workforce to use SharePoint. Now.
Click
here to read the rest of Product Watch: Developer Training
Solutions Without the Instructor
|
SQL Connections, March 22-25, 2009, Orlando,
Florida
The first 800 paid attendees receive SQL Server 2008 Standard with one
CAL. SQL Connections is co-located with SQL Server, Microsoft ASP.NET,
Visual Studio & .NET, Architect, and SharePoint Connections. Register
for one and attend sessions of concurrent events FREE.
Register for SQL
Connections
Refer a Friend to SQL Server for Non-DB Specialists eLearning!
SQL MVP Allan Hirt heads up 6 fundamental SQL Server lessons tailored to
pros new to SQL Server on March 26 and April 30, 2009! For only $99 each
day, you'll learn how to plan, deploy, and administer SQL Server. The
discussion will include aspects of SQL Server 2000, SQL Server 2005, and
SQL Server 2008.
Seats are limited to allow for lots of live Q&A at the end. Tell your
friends to register today!
Improve Desktop Security and Maintain End User Productivity
Removing end users’ administrator rights is an easy solution for
desktop security but can also hinder everyday tasks and productivity. In
this free online seminar, Microsoft MVP Derek Melber discusses best
practices for ensuring high security and maximum availability for
everyday client operations plus expert strategies for effectively
removing administrator rights so that users can perform all necessary
tasks for their jobs.
Learn what you need to know about security and administrative privileges
on desktops. Register for this free seminar today!
FEATURED WHITE PAPER
Get a Unified Solution for Managing Active Directory and Group Policy
on non-Windows Computers
The growing popularity of Mac computers in the business world presents
unique challenges to IT administrators who have to integrate them into a
Windows-based system. This white paper explains the benefits of
utilizing an integration solution that allows administrators to extend
Active Directory and Group Policy to Macs, simplifying identity
management, security, and compliance.
Download this white paper today to learn how easily
you can you can assimilate Macs into your Windows environment!
ANNOUNCEMENTS
Manage Cost in Your Enterprise with Business Process Automation
Discover the basics of business process automation, how BPA tools work,
and how they can benefit both IT and overall business efficiencies.
You'll learn where BPA can fit into your existing business process
model, how BPA differs from other basic scripting and scheduling
techniques, and what benefits your business model can derive from
implementing a BPA solution.
Download this free eBook today and make your
enterprise more efficient.
Free Software Trial Download: SureSync Makes Data Backup and
Management a Breeze
Do you need to find a backup solution that ensures the high availability
of your data to everyone in your enterprise while maintain data
integrity? SureSync from Software Pursuits will allow you to maintain
uniformity of web content, file permissions, and files modified by users
in real-time.
Try this software free for 30 days!
Data Protection and Disaster Recovery Tips
Learn how to protect and secure data in the event of a disaster by
making plans based on the expected duration of recovery, the impact of
the disaster on your facilities and the surrounding area, and other
factors. Even if you don't live in a disaster-prone area, you should
still be prepared for things such as structure fires, major traffic
accidents, and the like.
Make a disaster plan that works for your organization–Download this eBook today!
|
|
|
|