SQL server Archives - TechBubbles

For XML Auto Mode Example in SQL Server

January 28, 2014

SQL server, SQL Server 2012

For XML clause in Select Query allows you to return the query results in XML format. You can specify Auto, RAW, EXPLICIT and PATH in For XML clause. This post shows an example on Auto Mode. Auto Mode generates the…

Unit Testing for SQL Server in Visual Studio 2013

January 10, 2014

Kalyan Bandarupalli

SQL server, Visual Studio, Visual Studio 2013

Unit Testing is commonly leveraged in application development and this can applied to database development as well, In Visual Studio 2013 integrated database testing can run directly against the database.It can even be configured automatically in the team build scenario.…

Schema Compare for SQL Server in Visual Studio 2013

January 9, 2014

Kalyan Bandarupalli

SQL server, SQL Server 2012, Visual Studio, Visual Studio 2013

No Comments

This post outlines the new Schema Compare and Data Compare features in Visual Studio 2013 which supports SQL Server and Windows Azure databases. Schema Compare provides the capability to analyse and compare database schema along with presenting the results in…

Enabling Remote Connections in SQL Server 2012

April 20, 2013

Kalyan Bandarupalli

SQL server, SQL Server 2012

No Comments

You may get an error saying server was not accessible or not found or remote connections may not be configured properly. You will receive this error when database server is down or SQL Server is not configured for remote connections.…

Tabular Models and Multidimensional Models in SQL Server 2012

February 5, 2013

Kalyan Bandarupalli

SQL server, SQL Server 2012

No Comments

Tabular Model is a new data model introduced in SQL Server 2012 Analysis services. Tabula Models are in-memory databases which uses analytic engine named (VertiPaq) which delivers fast access to data to client applications like Excel and Power View.…

Server Management Tips for SQL Server

January 6, 2013

Kalyan Bandarupalli

SQL server, SQL Server 2012

No Comments

Administrating the Server resources such as memory, processes and storage and low level resources such as locks, latches and queues are crucial as these are consumed by transactions. This post outlines some tips on managing server level and database level…

Creating a Plan Guide in SQL Server 2012

January 5, 2013

Kalyan Bandarupalli

SQL server, SQL Server 2012

No Comments

Plan Guide is a very nice feature in SQL Server that allows you to apply hints to your queries without having to change the query type or text in the application. Plan Guides influence query optimization by using the query…

Performance tuning essentials for SQL Server DBA

January 4, 2013

Kalyan Bandarupalli

Performance tunning, SQL server

No Comments

This post outlines various options and tools for performing performance tuning on SQL Server. Performance tuning is ongoing, iterative process and it never stops. Typical performance tuning methodologies a Instance level Database level Application level Tuning the SQL Server while…

Big Data and StreamInsight

December 19, 2012

Kalyan Bandarupalli

Big Data, SQL server, SQL Server 2012

No Comments

StreamInsight in SQL Server is a Complex Event Processing Engine which can manage and mine the data in real-time. A practical application has developed to stream Twitter data and analyze this data with Microsoft Azure and Hadoop. Application can be…

Encrypting the session with SSL in SQL Server

November 26, 2012

Kalyan Bandarupalli

SQL server, SQL Server 2012

No Comments

Network packets are human-readable using a packet sniffer when SQL results passing between client machine and SQL server. Tabular Data Stream(TDS) is the protocol used by SQL server to form packets to be sent through the network. This post explains…