SQL Server

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 file and filegroups

Tips for using SQL Server 2012 file and filegroups Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these new features, but usually using them provides more easy and effective way to accomplish the same goal. For example, Microsoft introduces SQL Server FILESTREAM technology that enables SQL Server-based applications to...

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.
Log In Register
Pro Members SQL Server Standard Members

Tips for Minimizing Deadlocks

Tips for Minimizing Deadlocks By Basit A. Farooq The Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases the likelihood of conflicts because multiple processes can request access to same resources at the same time. This type of conflict is also known as block or blocking. The blocking usually...

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.
Log In Register
Pro Members SQL Server Standard Members

Five Follow-Up Steps for an Important Interview

Five Follow-Up Steps for an Important Interview Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve WynKoop and I talk about designing and managing our professional careers on a weekly interview on SSWUG.org. This...

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.
Log In Register
Pro Members SQL Server Standard Members

Database Administration in an Increasingly Complex World

Database Administration in an Increasingly Complex World by Craig S. Mullins The Database Management Systems we use every day are becoming more and more complex – there can be no denying this basic fact of life. Whether you are using DB2 or SQL Server or Oracle or any other popular DBMS, each and every new version adds new features, functionality,...

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.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2012 Linked Servers Optimization Tips

SQL Server 2012 Linked Servers Optimization Tips Try to avoid the ad hoc queries that use the OPENROWSET or the OPENDATASOURCE functions to access remote data. Create a linked server and perform a linked server’s query instead of using an ad hoc query with OPENROWSET or OPENDATASOURCE functions. Using the linked server’s queries to access remote data is more efficient...

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.
Log In Register
Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 2 by William E. Pearson, III In this, the second of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose member and set functions that we can use to perform analysis within the context of time. As we discussed in Part 1,...

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.
Log In Register
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 6)

XML Support and SQL Server (Part 6) By Basit A. Farooq Editor’s Note: This is the sixth part of my XML support and SQL Server article series. In this part, you will learn about the XML primary indexes and secondary indexes. XML indexes As we all know that XML query processing is resource-intensive, because SQL Server parses the XML instance...

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.
Log In Register
Pro Members SQL Server Standard Members

Learning SSAS-Part IV: Deploying and Processing a cube

Learning SSAS-Part IV: Deploying and Processing a cube Hello and welcome to the fourth part of this series dedicated to learning SQL Server Analysis Services. In the previous articles you learnt the basics of Analysis Services. I talked about data sources, data source views, diagrams, calculated columns etc. before actually building an OLAP cube based on a star schema using...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Integration Services

Troubleshooting SQL Server 2012 Integration Services If you have problems with SQL Server 2012 Integration Services (SSIS), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Integration Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At 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.
Log In Register
Pro Members SQL Server Standard Members

The Public Role — a potential high risk security concern for DBAs

The Public Role – a potential high risk security concern for DBAs By Basit A. Farooq In this article, I’ll discuss the security issues associated with the public database role, and how you can quickly find privileges granted to the public database role in each database. Finally, I’ll discuss how you can properly revoke the privileges granted to public database...

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.
Log In Register