SQL Server Reporting Services 2012 Permissions
As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report.
2012-10-31
3,976 reads
Additional Articles
SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages
Quite often, tasks accomplished via SSIS are a part of procedures that run unattended, either scheduled to launch at a particular date and time or triggered by some arbitrarily chosen event. Marcin Policht shares a typical approach to implementing such a scenario.
2012-10-30
3,399 reads
The PoSh DBA: Solutions using PowerShell and SQL Server
PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks.
2012-10-29
3,321 reads
Understanding Column Properties for a SQL Server Table
Designing a table can be a little complicated if you don’t have the correct knowledge of data types, relationships, and even column properties. In this tip, Brady Upton goes over the column properties and provides examples.
2012-10-26
4,430 reads
Getting Started With XML Indexes
XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running queries against half a million XML employee records. The execution time of a query is reduced from two seconds to being too quick to measure, purely by creating the right type of secondary index for the query.
2012-10-25
2,575 reads
SQL Server Semantic Search to Find Text in External Files
Sometimes it is necessary to search for specific content inside documents stored in a SQL Server database. Is it possible to do this in SQL Server? Can I run T-SQL queries and find content inside Microsoft Word files? Yes, now with SQL Server 2012 you can do a semantic search.
2012-10-24
2,154 reads
Tune Your Indexing Strategy with SQL Server DMVs
SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.
2012-10-23
4,324 reads
Archiving SQL Server Data Using Partitioning
Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.
2012-10-22
3,934 reads
Exporting Master Data from Master Data Services
This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.
2012-10-19
3,422 reads
Exploring Semantic Search Key Term Relevance
SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come up with a system to rival the industry-leaders, one that could extract the contextual meaning of terms in text, or automatically categorise the subject matter of text? On first inspection, it seems unlikely.
2012-10-18
2,985 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers