Standard Members

Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2012

by

Tips for using ASP.NET with SQL Server 2012 Try to avoid using ADO methods to access SQL Server data in your ASP. Use SQL Server 2012 stored procedures instead of ADO methods. By doing so, you can reduce network traffic and boost overall ASP.NET performance. If you use ADO to access SQL Server data in your ASP.NET, try to avoid...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
DB2 Pro Members Standard Members

Managing DB2 for z/OS Application Performance

by

Managing DB2 for z/OS Application Performance By Craig S. Mullins Applications that access databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance tuning and management is one of the biggest demands on the DBA’s time. When asked what is the single most important or...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Data, Information, and Business Intelligence

by

Data, Information, and Business Intelligence By Yuli Vasiliev In a BI system, information you need can be derived from different data sources, and by different means. Once it’s been derived, however, it doesn’t matter where it has come from, thus allowing consumers concentrate on the business aspects rather than on the specifics of the internal structure. It’s important to realize,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Learning SSAS Part VII – Attribute Relationships

by

Learning SSAS Part VII – Attribute Relationships Hello and welcome to the latest article in the Learning SQL Server Analysis Server series. The series started with the basic terminologies and techniques in Analysis Services before moving on to more complex things like building cubes. In the previous few articles we started diving deeper with hierarchies, advanced dimension properties and the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2012 Temporary Tables Optimization Tips

by

SQL Server 2012 Temporary Tables Optimization Tips Use local temporary tables instead of SQL Server 2012 cursors. Because using temporary tables usually are more efficient than using cursors, you should use temporary tables instead of cursors whenever possible. Try to avoid using temporary tables inside your stored procedure. Using temporary tables inside stored procedure reduces the chance to reuse the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

What’s In a Name? On Database Naming Standards

by

What’s In a Name? On Database Naming Standards By Craig S. Mullins The establishment and enforcing of naming conventions is often one of the first duties to be tackled when implementing new software. Adequate thought and preparation is required in order for such a task to be successful. What amount of effort should be extended in the creation of appropriate...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1

by

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1 This is the first article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. The primary focus of this series will be an introduction to PowerPivot for Excel and the Data Analysis eXpressions (“DAX”) language. The series is designed to provide hands-on...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2012 Transact-SQL Optimization Tips

by

SQL Server 2012 Transact-SQL Optimization Tips Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Avoid using optimizer hints in your...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Development Pro Members Standard Members

Understanding SSIS Package Configurations

by

Understanding SSIS Package Configurations Author: Basit A. Farooq Introduction Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages. This is because they need to be modified appropriately to ensure smooth deployment of ETL application. SQL Server Integration Services (SSIS) provides package configurations that help you to manage such configuration...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Testing Oracle Database With Pre-built VM

by

Testing Oracle Database With Pre-built VM By Yuli Vasiliev You don’t have to prepare your system, download, and then install an Oracle database to be able to test it. You can significantly simplify the database installation process by using the pre-built Database App Development VM appliance running within Oracle VM VirtualBox. This appliance is available for download from the Pre-Built...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 86 87 88 89 90 … 110