programming4us
programming4us
DATABASE
Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 >  |  Displaying page 12 of 16, items 441 to 480 of 625.
SQL Server 2008 : Auditing SQL Server - Creating Server Audit Specifications
The server audit specifications are tracked across the entire instance of SQL Server. There are not any boundaries within the SQL Server instance
SQL Server 2008 : Auditing SQL Server - Creating SQL Server Audits with T-SQL
The audit does not contain any information about the actions either at the database level or the server level within its definition
Programming Microsoft SQL Serve 2005 : An Overview of SQL CLR - Security
Depending on the deployment method, you have numerous ways to specify what security level to grant a CLR assembly.
Programming Microsoft SQL Serve 2005 : An Overview of SQL CLR - CLR Aggregates
The SQL CLR features in SQL Server 2005 allow us to implement user-defined aggregates in .NET code and use them from T-SQL
SQL Server 2008: Monitoring Resource Governor
Resource Governor monitors provide you with the essential data needed to alter and adapt your configuration based on informed decisions instead of just making random configuration changes and hoping for the best.
SQL Server 2008: Managing Resources with the Resource Governor (part 3) - Classifier Function
The classifier function is a T-SQL function that is executed for each login, which allows you to write logic to route incoming requests to the appropriate workload group.
SQL Server 2008: Managing Resources with the Resource Governor (part 2) - Workload Groups
The Resource Governor uses workload groups as a way to segregate all incoming requests that have predefined common characteristics together as a single unit.
SQL Server 2008: Managing Resources with the Resource Governor (part 1) - Resource Pools
Resource pools are based on the memory and CPU that is available to the SQL Server instance where you are configuring the Resource Governor, not the total resources available to the OS.
SharePoint 2010 : SQL Backup Tools
Although the backup options out-of-the-box in SharePoint give an array of tools to back up the configuration and the content databases; critical SQL Server databases such as Master, MSDB, and TempDB cannot be backed up by these tools from within SharePoint.
Windows Azure : Storing static reference data with dynamic data
Regardless of your chosen storage platform (SQL Azure or the Table service), you should consider caching static data rather than continually retrieving the same data from a table
SQL Server 2008 : Managing Query Performance - Adding Hints Through Plan Guides
SQL Server 2008 has actually taken plan guides a step further so that you can provide an entire XML query plan as a query hint.
SQL Server 2008 : Managing Query Performance - Forcing a Specific Execution Plan
Plan forcing is useful when the query optimizer will not produce an optimal execution plan for a query, even though you know a better execution plan is available.
Programming Microsoft SQL Server 2005 : An Overview of SQL CLR - CLR Triggers
T-SQL triggers are really just stored procedures that are called by SQL Server at specific times and query values in the “inserted” and “deleted” pseudo-tables.
Programming Microsoft SQL Server 2005 : An Overview of SQL CLR - CLR Functions
As any programmer knows, a function is a lot like a procedure, except that it returns a value (or an object) . Mainstream .NET functions typically return .NET types. SQL CLR functions, on the other hand, must return a SqlType
SQL Server 2008 : Performance Tuning - Using Dynamic Management Views
Dynamic Management Views (DMVs) are almost certainly the single most useful tool for troubleshooting and performance tuning SQL Server databases.
SQL Server 2008 : Performance Tuning - Working with Database Tuning Advisor
The Database Tuning Advisor (DTA) is a tool provided with SQL Server to help Developers and System Administrators improve query performance by optimizing physical design structures such as indexes, indexed views, and table partitioning.
SQL Server 2008 : Performance Tuning - Tracing with SQL Profiler
If SQL Server is running on a shared server (perhaps with a third-party application or Web server such as Internet Information Services), System Monitor can help you find the process consuming resources.
SQL Server 2008 : Performance Tuning - Working with Query Execution Plans
An execution plan is a plan containing the steps SQL Server works through in order to satisfy a query. Most stored procedures or ad hoc Transact-SQL queries access more than one table, and most tables have a clustered index and usually multiple non-clustered indexes.
Externalizing BLOB Storage in SharePoint 2010 (part 2) - Installing and Configuring RBS & Migrating and Moving BLOBs Between BLOB Stores
Administrators can use the following procedure to install and configure the BLOB externalization in SharePoint 2010 using RBS and the RBS FILESTREAM provider
Externalizing BLOB Storage in SharePoint 2010 (part 1)
Remote BLOB Storage (RBS) is a library API set designed to move storage of large binary data (BLOBs) from Microsoft SQL Server to external storage solutions.
Sharepoint 2010 : Managing SharePoint Content Databases
Some of these tasks can be completed directly from central administration; others can be done only via PowerShell or the deprecated STSADM command-line utility
Sharepoint 2010 : Maintaining SQL Server in a SharePoint Environment
To keep SharePoint operating smoothly and with optimal performance, it is highly recommended that SharePoint administrators conduct regular maintenance on each SQL Server database
Sharepoint 2010 : Monitoring SQL Server in a SharePoint Environment
Understanding monitoring strategies and tools enables administrators to shift from reactively dealing with issues to proactively troubleshooting and fixing problems before the server gets to the point where end users are impacted
Database Availability Group Replication in Exchange Server 2010 : Load Balancing in Exchange Server 2010
Another high-availability technology provided with the Windows Server 2008 platform is Network Load Balancing (NLB). NLB clusters provide high network performance and availability by balancing client requests across several server systems.
Database Availability Group Replication in Exchange Server 2010 : Comparing and Contrasting DAG Versus CCR/SCR/SCC
For administrators coming from an Exchange Server 2003 or Exchange Server 2007 environment looking to upgrade to Exchange Server 2010, it may prove useful to compare and contrast Database Availability Groups to existing replication technologies that one might already be familiar with.
SQL Server 2008: Managing Query Performance - Forcing Index Seeks
The query optimizer does a really good job deciding whether a seek or scan is more efficient, but in certain scenarios you may want to override the execution plan's decision.
Exchange Server 2010 : Deploying a Database Availability Group (part 4)
Many Exchange Server administrators have embraced the Exchange Management Shell as the preferred tool for configuration. Doing things via the shell has many advantages
Exchange Server 2010 : Deploying a Database Availability Group (part 3)
Many Exchange Server administrators have embraced the Exchange Management Shell as the preferred tool for configuration. Doing things via the shell has many advantages
Exchange Server 2010 : Deploying a Database Availability Group (part 2) - Suspending and Reseeding a Database
In the event that a replica of a mailbox database should become out of sync with the primary copy, it becomes necessary to reseed the database in order to resume the replication of log files
Exchange Server 2010 : Deploying a Database Availability Group (part 1) - Creating the File Share Witness
One of the components required for this function is a file share witness. Administrators familiar with Exchange Server 2007 may recall that a file share witness acts like a voting node in a cluster, specifically a Majority Node Set cluster
Database Availability Group Replication in Exchange Server 2010 : Understanding Database Availability Groups
A Database Availability Group is a group of up to 16 Exchange Server 2010 mailbox role servers that replicate mailbox data to each other and that can perform automated recovery at the mailbox database level in the event of a hardware, storage, or network failure.
SQL Server 2008 : Managing Query Performance - Optimizing for Specific Parameter Values
The OPTIMIZE FOR query hint was introduced in SQL Server 2005 to allow you to specify a value the query optimizer will use when creating an execution plan for parameterized queries
SQL Server 2008 : Managing Query Performance - Running the Standard Performance Reports
Microsoft has written some out-of-the-box reports that offer some useful information when looking for problematic queries.
SQL Server 2008 : Explaining XML - Well-Formed XML
XML is a framework for storing information in a tree. The XML document must exactly have one root tag and must have a start-tag and end-tag . An XML document must adhere to the XML syntax rules, or it is not a valid document
SQL Server 2008 : Explaining XML - XML Schema
XML schemas provide a means to define the structure and content of an XML document. SQL Server supports a subset of the XML Schema and uses three DDL statements to manage XML schema collections
SQL Azure : Tuning Techniques (part 5) - Provider Statistics & Application Design
Certain coding techniques can negatively affect performance, such as excessive roundtrips. Although this may not be noticeable when you're running the application against a local database, it may turn out to be unacceptable when you're running against SQL Azure.
SQL Azure : Tuning Techniques (part 4) - Indexed Views & Stored Procedures
Indexed views are an excellent alternative when you absolutely need to JOIN data, and traditional indexing doesn't yield the performance you're looking for
SQL Azure : Tuning Techniques (part 3) - Indexing
Creating the right indexes can be complex; it can take a long time to fully understand indexing and fine-tune database queries. One of the most important things to remember with indexing is that its primary purpose is to help SQL Azure find the data it needs quickly.
SQL Azure : Tuning Techniques (part 2) - Connection Pooling & Execution Plans
In SQL Server, you can also use execution plans to observe the impact of changes to the underlying hardware, such as changing memory configuration.application
SQL Azure : Tuning Techniques (part 1) - Dynamic Management Views
he integration of tilt is pretty straightforward, and in the end it will certainly be completely up to you whether you would like to use it within your application
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
REVIEW
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
programming4us
 
 
programming4us