Walking through what’s new in querying SQL Server 2012

Hi,

I’ve just been experimenting with the new T-SQL functions and I’ve compiled a set of queries demonstrating them.

This is mainly a demo of the new functionality and I’ve added some useful hints here and there – if anyone has more information about the performance etc, please comment below.

NOTE: I Know this data structure is terrible…don’t bring that up…it’s a demo.

This demo of SQL functionality contains the SQL code for demo data allowing you to execute each query and tinker around with the examples.
Read more “Walking through what’s new in querying SQL Server 2012”

How to allow a user with an SQL login to manage SQL Server Agent

I was placed in an interesting situation where I needed to manage SQL Server jobs from a web application, which would sit on a completely different server and I was only allowed to use SQL Logins (not Windows logins) to perform any SQL task, I needed a way to use an SQL server login to manage SQL Server agent jobs.

NOTE: I will be writing a tutorial on managing SQL server jobs via C# but if you’d like me to put a rush on it please let me know in the comments below.

The steps needed to set up an SQL login with sufficient permissions to manage SQL Server jobs are mentioned below.
Read more “How to allow a user with an SQL login to manage SQL Server Agent”