(Kevin Beaver) In a previous tip, 10 hacker tricks to gain access to SQL Server, I outlined various ways SQL Server can be compromised. Here I’m going to expand upon a couple of vulnerabilities that I see time and time again when performing security assessments. (R)

(Alex Kozak) Database performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence, many a performance optimization and tuning book discusses the ways to make queries faster. Even RDBMS ma

(Douglas Reilly) In Part I of this series, I discussed the role and value of conferences in the career development of SQL Server and .NET developers. In this article, I move on to discuss online technical forums, focusing on what to do before you post on a newsgroup or forum in order to derive maxim

(Deac Lancaster) This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.

(Rodney Landrum and Walter J. Voytek II) SSRS 2005 offers software developers a variety of options when it comes to customizing reports through code. These options give software developers the ability to write custom functions using .NET code that can interact with report fields, parameters, and fil

(Sushila Bowalekar Patel) In this article, I will examine how to create a BoundField Column dynamically for a GridView control. The demonstration shows the ListBox populated with Column Names from a specific table. Selecting multiple column names from the ListBox will allow the user to display the d

(beeeen) Microsoft has recently released Reporting Services, an enterprise level reporting system. Reporting Services (RS) is now easily obtainable and most likely will be bundled with SQL Server starting with its next release. This makes RS not only powerful, but convenient. However, being a ne

(Jayaram Krishnaswamy) DTS, an integral part of MS SQL 2000 server, moves data very easily between MS SQL Servers and between Microsoft products. However, it can also reliably move data to and from non-Microsoft databases. Although DTS requires a Microsoft license, it can be implemented independentl

(William Pearson) As I have shown in many past articles, including Part One of this session, the Microsoft Integrated BI Solution, consisting of the MSSQL Server 2005 Database Engine, Analysis Services 2005 and Reporting Services 2005, provides unprecedented flexibility in helping implementers and d

(William Ryan) Quite often, databases evolve into things that their original designs never had in mind. This usually isn’t good. There’s also not much you can do about it, ‘feature creep’ is a fact of life in the IT field. However, as a develoep or DBA, you often get ‘deal breaker’ requests that