Featured Article(s)
Building Simple Reports with Reporting Services (Part 1 of 5)
We're going to show how to create both simple reports and reports with variables. We will discuss how to manage those reports once you’ve created them including how to secure your reports. And finally we will...(more)
We're going to show how to create both simple reports and reports with variables. We will discuss how to manage those reports once you�ve created them including how to secure your reports. And finally we will discuss how to allow your users to access those reports. Throughout the session we will be doing demos of nearly every feature of Reporting Services.
(Mahesh Chand) A RadioButton control provides a round interface to select one option from a number of options. Radio buttons are usually placed in a group on a container control such as a Panel or a GroupBox and one of them is selected.
(Sheryl M. Larsen) Few things do well without proper care. Houses, cars, pets, friends, and family all need our attention to stay happy and healthy, and database management systems are no different.
(Deanna Dicken) As enterprises add systems and acquire companies, they will most likely find themselves faced with a growing inconsistency amongst core data utilized by their key systems. This leads to an inability to provide quality data to management. Master Data Services for SQL Server provides a means to centrally manage and serve up this critical enterprise data.
(Scott Mitchell) Last week's article, Implementing the Store Locator Application Using ASP.NET MVC (Part 1), started a two-part article series that walked through converting my ASP.NET store locator application from WebForms to ASP.NET MVC. Last week's article stepped through the first tasks in porting the store locator application to ASP.NET MVC, including: creating the new project; copying over stylesheets, the database, scripts, and other shared content from the WebForms application; building the HomeController; and coding the Index and StoreLocator actions and views.
(Malcolm Sheridan) In the last couple of weeks, we've been able to see what the future holds for ASP.NET MVC with the release of ASP.NET MVC 3 Preview 1. This is the first public release of MVC 3 and there are some notable additions to the framework. The biggest in my opinion is the new Razor view engine. You've always had the ability to plug in thrid party view engines such as Spark, but now out of the box, Microsoft has introduced the new Razor view engine. What this engine aims to do is simplify the HTML and readability of your view. Another bonus is less code to write because of the new syntax. This article will go through how to setup a new project, and a future article will outline the new Razor syntax.
(Willie Favero) On September 21, IBM will be presenting a no-charge Webcast "TCO news: Optimizer in DB2 10 for z/OS Beta" featuring optimization expert Terry Purcell. Here's an opportunity to find out what the enhancements and additions to DB2's optimizer in DB2 10 will do for you.
(Michael Sansoterra) It eventually happens to every developer. You write a stored procedure to return one or more sophisticated result sets to a Java or .NET client. Everyone is (temporarily) happy. Eventually, a need arises for an RPG or COBOL program to execute this stored procedure and process the result set(s). But, alas, high level language programs have no way to open and process a result set (except when using the cumbersome CLI API).
(Pinalkumar Dave) Let�s see another reason why I do not like Views. Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away.
(Ged Mead) One of the great advantages of WPF is that you can place a wide variety of different content in or on its controls. Buttons are no exception, and you can create more interesting looking buttons by combining some of WPF�s graphics features.
(Henrik Loeser) In two posts in the past, I explained how to say no to invalid data and how to find out what data was wrong and causing errors. With the REJECT INVALID VALUES clause during CREATE INDEX it is possible to reject XML documents that have values in the specified XPath location not compliant with the specified data type. Now the question I got is: What is better, to reject invalid values or to ignore them?
(Edmond Woychowsky) I really like Altova�s MapForce for generating XSLT, but it shares something with every tool that generates XSLT: the warnings in the generated code (Listing A). These warnings essentially say that if you modify the generated code, you can kiss your code goodbye when you regenerate, because your code will be overlaid. While this might sound like Project Genesis to some, there is a way to modify the generated code and survive.
(Luc Bors) A little over two years ago I wrote a post on drag and drop in an adf tree component. That post was based on ADF only. In the following post I show that you can have JHeadstart generate a tree for you that supports drag and drop.
(Kellyn Pedersen) A common initial resolution to reporting requirements without a reporting database is to utilize materialized views. Unfortunately, the cost to refresh these views can be extremely expensive on a database, especially if it's an OLTP that rarely has a lull in activity.
(Charles Hooper) As I am sure that you are aware, there are compatibility problems between Oracle Databases and Oracle Clients that are from different releases. The Oracle Database 11.1 documentation states the following:
(Tim Ford) I make no attempt to hide my dislike for Performance Monitor. Don't get me wrong - it is a good product, but I'm a Transact-SQL kind of guy and I'm at the point after this many years as a SQL Server Professional where I expect to get all my information at the bottom of a white screen in tabular format. Queries, performance information, kids' report cards, letters from my wife... Yes, I'm a SQL Server Management Studio Junkie and I will not change any time soon. What is a guy like me supposed to do when it comes to getting performance information - specifically performance counters that I would expect to see in Performance Monitor (aka PerfMon) - in SSMS?
Featured Article(s)
SQL Server 2008 Temporary Tables Optimization Tips
In this article, you can find some tips to use SQL Server 2008 temporary tables.
Bit Mapping Rewind
So I've been playing with Bit Maps and had a few things to share as a follow up of the editorial of 8/20/2010.
Like mo...(more)
Microsoft’s new Silverlight-based app provides database management from a browser, a convenience that could be extended to non-cloud databases in time.
Last Day to Register for the SSIS class...
12 sessions a month of learning, lots of help from SQL Server MVP Eric Johnson, all about SSIS. You can't go wrong!
Check it out here to get more information - class starts Sept 1!
Is There a Shortage of SQL Server Experts?
I came ...(more)
New selecTViews Video Posted
Today Ben Miller joins me on selecTViews. We talked about how companies work with developer and DBA teams, what works, what doesn't and a lot more.
[Check out the show here]
Free Webcast Available Now:
Get Your Implementation Organized
When it comes ...(more)
New selecTViews Video Posted
Today Ben Miller joins me on selecTViews. We talked about how companies work with developer and DBA teams, what works, what doesn't and a lot more.
[Check out the show here]
Featured Article(s)
Importing Geospatial data from MS Excel 2010 to SQL Server 2008...(more)
The use of SQL Server Management Objects streamlines the process of scripting database objects, allowing DBAs and developers to customize code using basic SMO scripting know-how.
Service Accounts � Web Applications � Application Pools � File Locations � Database Names� when it comes to SharePoint environments, if you don�t plan ahead, your environment can quickly become a disorganized mess of IIS, SQL & SharePoint components. Suddenly you don�t know what web application maps to what application pool in IIS, or even worse, you don�t know what service accounts perform what functions! This session will cover strategies and provide recommendations on ways that SharePoint administrators can reign in their farm � and make sure that no matter who is managing it, everyone is on the same page. Organization is key � and this session will help get you one step closer to organization nirvana.
Presented by: Christopher Regan
Sponsored by: AvePoint (www.avepoint.com)
With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.
Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.
Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.
Not all certs are created equal, but changes to Microsoft’s certification track over the past few years have left some database professionals curious about what to pursue.
Cool new features may not impress management, but return on investment always will. Speak an executive’s language when making the hard pitch for a SQL Server 2008 R2 upgrade.
While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.
Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.
Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.
You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we'll explore change management (the fluffy kind) strategies that can be tailored to your user base. Attract users, and keep your budget!
Presented by: Adam Levithan
Sponsored by: AvePoint (www.AvePoint.com)
With careful planning, DBAs can get similar functionality to Microsoft’s MDS feature -- without migrating to R2 -- by taking advantage of older SQL Server technologies.
Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here.
SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.
SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.
Log Shipping has been around in one form or another since SQL Server 2000 and many �homegrown� and third-party solutions have recently become available. This session will cover all you need to know about log shipping to use it effectively for high availability. We will look at set up, maintenance, monitoring, and failover. In addition, we will look at other SQL Server objects that you need to account for when using Log Shipping for HA. This session is for beginning to advanced SQL Server DBAs with little or no Log Shipping experience.
Presented by: Eric Johnson
Sponsored by: Idera (www.idera.com)
Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.
Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.
Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.
Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.
When a database outgrows its server, DBAs have the option of either scaling it out across multiple systems or moving to a more powerful server. Here are the factors to consider.
It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.
It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.
MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more.
MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more.
This session takes you on a end-to-end tour of management features for Analysis Services. Along the way, you�ll learn important best practices direct from the product team about how to configure, optimize and manage your Analysis Server. We expect this to be an essential session for new and experienced Analysis Services administrators alike.
Presented by: Donald Farmer
Sponsored by: SQL Sentry (www.sqlsentry.net)
Searching databases for specific objects can be frustrating – especially when you can’t recall exactly where said objects are. Fortunately, there are tools out there that can help.
A business intelligence solution can present data in a variety of ways, such as dashboards, scorecards and reports, but each form has a little something different to offer.
The power of aggregate functions goes well beyond the basics. This tip demonstrates how to work with grouped data, verify checksums, and retrieve detailed statistics.
Understanding how to work with aggregate functions can open new doors to the types of information retrieved from your database -- and it may not be as tricky as you think.
Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.
With the promise of providing simple, self-service BI analysis for users, the time has come to put Microsoft’s new PowerPivot technology through its paces.
Not sure what to make of R2? Here you’ll find answers to some of the most common questions involving the latest database server release from Microsoft.
String functions offer flexibility to your T-SQL statements – once you understand how they work. As you might expect, the best place to start is with the functions themselves.
There’s plenty more to learn about string functions beyond the basics. Here you’ll find details on more advanced practices, like performing a SOUNDEX analysis.
String functions offer flexibility to your T-SQL statements – once you understand how they work. As you might expect, the best place to start is with the functions themselves.
There’s plenty more to learn about string functions beyond the basics. Here you’ll find details on more advanced practices, like performing a SOUNDEX analysis.
Configuration is an important first step for setting up Master Data Services. But what about loading the data? Here is the step-by-step process for R2.
Configuration is an important first step for setting up Master Data Services. But what about loading the data? Here is the step-by-step process for R2.
When it comes to performance, the most basic techniques can make all the difference. Learn which PerfMon counters to be on the lookout for when tuning your SQL Server environment.
Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English.
Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English.
SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports.
Manual testing for SQL injection requires a lot of effort with little guarantee that you'll find every vulnerability. Fortunately, there is a better way.
It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.
Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.
Report Builder can be an extremely useful tool for generating reports in SSRS. This page provides resources on how to properly utilize all of its functionality.
We've tallied a Top 10 collection of backup and recovery tips for 2006. View the complete list where database restores of different shapes and sizes took the majority of slots.
