Additional Articles

Issues Determining an Individual SQL Server User's Permissions

by Additional Articles

MSSQLTips.com

Security

Recently I was supporting a third party application. It queries to determine what tables it has permissions to before it proceeds with the rest of its functionality. We had implemented permissions based on the best practice of creating roles, assigning the permissions to the roles, and then making the users members of the roles. The application was querying INFORMATION_SCHEMA.TABLE_PRIVILEGES and of course didn't find any permissions directly against the user in question. We ended up granting explicit permissions to the user so the application would work, but I'm more interested in the general case. How can I determine permissions for an individual user?

2012-08-02

3,152 reads

PowerShell SMO: Just Writing Things Once

by Additional Articles

SimpleTalk

PowerShell

Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in an SMO pipeline to access databases, it occurred to him that he should have only one pipeline to access databases in PowerShell, one reusable pipeline

2012-08-01

2,411 reads

Implement Continuous Integration In Your Software Project

by Additional Articles

DevX

software development

Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.

2012-07-31

2,538 reads

An Introduction to SQL Server Service Broker

by Additional Articles

Database Journal

Service Broker (SSSB)

Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing. The great thing about Service Broker is that its functionality is exposed so we can build our own custom data integrations. Deanna Dicken introduces you to the concepts needed to create a service broker integration.

2012-07-30

3,492 reads

Data Generator Source Adapter

by Additional Articles

sqlis.com

Integration Services (SSIS)

This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated. This component is used by us to do testing of the pipeline and components downstream.

2012-07-27

2,236 reads

NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server

by Additional Articles

SimpleTalk

Sparse Columns

Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.

2012-07-26

1,410 reads

Managing SQL Server Extended Events in Management Studio

by Additional Articles

MSSQLTips.com

Extended Events (XE)

We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?

2012-07-25

3,142 reads

Implementing SQL Server's Change Data Capture

by Additional Articles

Database Journal

Change Data Capture (CDC)

When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.

2012-07-24

2,689 reads

Developing Low-Maintenance Databases

by Additional Articles

SimpleTalk

Maintenance

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.

2012-07-23

3,977 reads

Creating a Custom Report Template in SSRS

by Additional Articles

Database Journal

Reporting Services (SSRS)

Arshad Ali shows you how to create standard/custom report templates in SQL Server Reporting Services (SSRS), to ensure consistency throughout the organization in both the look and feel of reports.

2012-07-20

3,930 reads

All authors

Additional Articles

Issues Determining an Individual SQL Server User's Permissions

PowerShell SMO: Just Writing Things Once

Implement Continuous Integration In Your Software Project

An Introduction to SQL Server Service Broker

Data Generator Source Adapter

NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server

Managing SQL Server Extended Events in Management Studio

Implementing SQL Server's Change Data Capture

Developing Low-Maintenance Databases

Creating a Custom Report Template in SSRS

Blogs

Git forked

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Forums

Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

The String Distance I

Question of the Day

The String Distance I