For all of us who deal with long web pages and need to scroll back to the top of the menu, here’s a nice alternative floating menus that follow you as you scroll down a page.
Author: SSWUG Research
SQL Server – Show/Hide Results Pane in Management Studio 2012
(Vishal Harishbhai Gajjar) In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard shortcut Ctrl+R. This shortcut was also present in Query Analyzer (SQL Server 2000).
SQL Tip: COALESCE
(Ember Crooks) I haven’t generally been known for my SQL tips. I can find my way around SQL decently enough, but for years, I didn’t do much of it. I’ve used it more and more as the years have gone by as I have moved out of a stictly physical/system DBA role and into a more mixed role where I […]
SQL INTERSECT Queries
(Mike Chapple) SQL’s INTERSECT operation allows you to identify the rows that appear in multiple source tables or SELECT query results. This set of common rows is known as the intersection of the two tables. The INTERSECT operation is related to the UNION operation that provides a listing of all of
Security Questions: What permissions are required to create temporary tables?
(Jason Strate) As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.
Retreive any complex data XML structure type from SQL using BizTalk WCF SQL Adapter
(Nino Crudele) I need to retreive any type structure data from a database with WCF SQL adapter, as you know thw WCF SQL adapter retreive a particular propetary structure and it doesn’ t permit to retreive complex structure data from a database, work with complex structure type from database with WCF
SSWUGtv: High Availablity solutions – key management, swapping servers, clustering…oh my!
Video Programming for IT Professionals
DirectQuery Mode in SQL Server 2012 Analysis Services (SSAS) Tabular
(Ray Barley) I am building a SQL Server 2012 Analysis Services Tabular model to support ad-hoc queries for a particular department within my organization. One of the requirements is that the database must always provide the most up-to-date data at all times.
A Quick Tour of Social Computing Features in SharePoint Server 2013
(Adam Gorge) There have been dozens of enhancements to the social computing and collaboration features in SharePoint Server 2013. The new features empower enterprise users to share information easily with others in the organization.
Using ASP.Net WebAPI with Web Forms
(mako_123) Asp.Net WebAPI is a framework for building RESTful HTTP services which can be used across a wide range of clients including web, phone and desktop applications. With WebAPI we can use XML and JSON to send and retrieve data from the service. The use of Json or XML makes it quite flexible t