Article on the subject of "sql server 2005"

  • Segment tables in SQL Server

    Segment tables in SQL Server

     table partitioning technique (table partitioning) to effectively manage the database with large capacity.
  • Improvements in SQL Server 2008 T-SQL command (Part 2)

    Improvements in SQL Server 2008 T-SQL command (Part 2)

     in the previous section we explored some of the improvements in sql server 2008 t-sql statements, including intellisense, grouping set, and forceseek hint tables.
  • EXECUTE AS statement in SQL Server 2005

    EXECUTE AS statement in SQL Server 2005

     in this article, we will explain the effect of the new execute as statement in sql server 2005 - execute as. this is a very useful utility for database administrators sql server 2005 when they need to check the permissions of each user.
  • Warning about serious vulnerabilities in SQL Server

    Warning about serious vulnerabilities in SQL Server

     systems running sql server 2000, sql server 2005, sql server 2005 express edition, sql server 2000 desktop engine (msde 2000), ... can be exploited and controlled
  • New Ranking functions in SQL Server 2005

    New Ranking functions in SQL Server 2005

     along with sql server 2005, microsoft introduced a number of new features and these features will make it easier for dba or sql server specialists to code and maintain sql server databases. this article will discuss h
  • Capture execution diagrams with SQL Server 2005 Profiler

    Capture execution diagrams with SQL Server 2005 Profiler

     executable diagrams are one of the best tools for diagnosing query errors in order to adjust the execution of queries on sql server. in previous versions of sql server 2005, the only option for query performance was text diagrams or graph execution diagrams for manual queries. on sql server 2005,
  • Checking Exchange Server 2007 with MOM 2005 (Part 1)

    Checking Exchange Server 2007 with MOM 2005 (Part 1)

     the main goal of this series is to show you how a mom 2005 sp1 tool supports the exchange server 2007 environment. exchange server 2007 has five separate roles (roles) and we will check to see the status of the root
  • Checking Exchange Server 2007 with MOM 2005 (Part 3)

    Checking Exchange Server 2007 with MOM 2005 (Part 3)

     mom 2005 administration interface: analysis of exchange server 2007 management pack changes. mom uses 3 types of data discrimination: event (event), alert (alert) and performance counter to check and save exchange server information.
  • Encryption in SQL Server 2005

    Encryption in SQL Server 2005

     encryption is an important method of data security. sensitive data such as cmt numbers, credit card numbers, passwords ... need to be protected against numerous current threats. in sql server 2000 you can create your own functions or use external dlls to encrypt data. in sql server 2005,
  • Checking Exchange Server 2007 with MOM 2005 (Part 2)

    Checking Exchange Server 2007 with MOM 2005 (Part 2)

     in part one, i showed you how to manage exchange server 2007 with mom 2005. in this second part, you have an environment that has exchange server 2007 management pack installed and exchange server 2007 internally installed with mom a.
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 8

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 8

     in this article, i will show you how to use powershell in conjunction with smo to display object properties for all sql server objects.
  • Improvements in SQL Server 2008 T-SQL command (Part 2)

    Improvements in SQL Server 2008 T-SQL command (Part 2)

     in the previous section we explored some of the improvements in sql server 2008 t-sql statements, including intellisense, grouping set, and forceseek hint tables.
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9

     in part 9 of this series, i will show you how to use powershell in conjunction with smo to create a sql server script. creating sql server scripts is an important task for administrators and sql server database development professionals.
  • Things to know about the new Virtual Server

    Things to know about the new Virtual Server

     virtualization technology is becoming increasingly popular. microsoft quickly recognized this trend and researched and released a test version of a virtual service product called virtual server 2005 r2. this first virtual server was bundled
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 10

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 10

     in part 10, i will show you how to use powershell scripts in conjunction with smo and parameters to create sql server scripts. creating sql server scripts is an important task for administrators and sql server database development professionals.
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 7

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 7

     each part of this series demonstrates how to use powershell in conjunction with smo to present sql server objects. part 7 of this series will demonstrate how to use powershell and smo to find all available objects in a database on the server.
  • Introduction to SQL Server Reporting Services

    Introduction to SQL Server Reporting Services

     sql server 2005, 2008 and 2008 r2 software packages are pre-packaged with sql server reporting services (ssrs) - a specialized report creation solution for businesses. with ssrs, you can completely create, publish, and manage a huge number of reports from various data sources ...
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 11

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 11

     part 10 of this article series showed how to use powershell scripts in conjunction with smo and parameters to create sql server scripts. in this section, we will show you how to use powershell cmdlets in conjunction with the sql server client and output saving to export to a text file or xml file.
  • Microsoft Windows Power Shell and SQL Server 2005 SMO - Part 4

    Microsoft Windows Power Shell and SQL Server 2005 SMO - Part 4

     part i and part ii of this series showed simple power shell settings, smo and wmi cmdlets. part iii instructs writing powershell and connecting to sql server. part 4 will show you how to use powershell code to iterate file content and connect to other servers.
  • Instructions for creating and editing reports in SQL Server Reporting Services

    Instructions for creating and editing reports in SQL Server Reporting Services

     sql server 2005, 2008 and 2008 r2 product suite, all packaged with sql server reporting services (ssrs) - a dedicated solution for creating reports for businesses. with ssrs, users can create, schedule, post and manage various reports from various sources of original data.
  • SQL Server 2005 - Next generation data analysis and management software

    SQL Server 2005 - Next generation data analysis and management software

     today, organizations are always faced with data difficulties: the development of data and systems in business operations; it is necessary to provide employees, customers and partners with access to data in a timely manner
  • Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 2

    Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 2

     part i of this series shows how to set up and use simple powershell and smo commands. in part ii we will learn more about powershell as well as its features associated with smo. if you do & ati