Blogs about: Sql
Featured Blog
Blogging Best Practices – Pluralsight Online Course Based on My Experience
I have been blogging for more than 6.5 years and I have so far written over 2500 articles on this blog and every blog has been journey itself. Over six years I have not missed any single blog and no m… more →
SQL Server Journey with SQL Authority
Blogging Best Practices - Frequently Asked Questions - Part 5
wrote 1 hour ago: Abstract of my Pluralsight Course Building a Successful Blog Module – Frequently Asked Questio … more →
The Truth About Cursors
wrote 1 hour ago: By: Spiros Psaroulis Created On: 24 May 2013 Updated On: I have always watched with curiosity when c … more →
SQL A Simple Procedure
wrote 3 hours ago: Greetings all, let’s create a simple procedure. First, we will create a new database and then … more →
Powerbass XL-104D Review
wrote 3 hours ago: Last we received our demo Powerbass XL-104D to install into the Landrover Discovery for people to au … more →
Automated SQL Runs = Maven + Jenkins + Github + dbdeploy
wrote 4 hours ago: Getting tickets with sql to run on stage? A Developer wants it to run at 8pm? Why do this manually? … more →
Interesting problem with SQL Server, ARITHABORT, filtered indexes, calculated columns, and compatibility mode of 80
wrote 7 hours ago: I recently ran into a problem in a legacy application. Someone had applied a unique index on a colu … more →
SQL SERVER - How to get short month name / weekday name from datetime
wrote 8 hours ago: I came across this question on multiple forums and it is being solved using multiple function such a … more →
India has become a global analytics hub
wrote 9 hours ago: Most Indian parents push their children to do well in mathematics. That push is now paying an unexpe … more →
Dicing the Beanstalk
wrote 14 hours ago: I’d like to describe a PLSQL Pattern that has to do with Formatting and Readability. A common … more →
SQL Query to convert date and time
wrote 19 hours ago: To convert the output of a date-time column you can use the following query: SELECT CONVERT(VARCHAR( … more →
Blogging Best Practices - Blogging Rules, Ethics and Etiquette - Part 4
wrote 1 day ago: Abstract of my Pluralsight Course Building a Successful Blog Module – Blogging Rules, Ethics a … more →
SQL - Creating useful views
— 1 comment
wrote 1 day ago: Creating views in SQL is incredibly easy and can be a very useful way of extracting certain data fro … more →
SQL SERVER 2012 - Fix - Error :11508 - The undeclared parameter is used more than once in the batch being analyzed.
— 1 comment
wrote 1 day ago: In my earlier article, I wrote about one of the new system stored procedure sp_describe_undeclared_p … more →
Concurrent is building a Hadoop assembly line in open source
wrote 1 day ago: If you know Java, R or SAS, doing machine learning on Hadoop data just got a lot easier. Concurrent … more →
Presenting 2 sessions at SQLPASS
wrote 1 day ago: I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have … more →
Field Datatypes available in Dynamics CRM 2011
wrote 1 day ago: Following datatypes are available in Dynamics CRM 2011 and corresponding SQL Server datatypes are sh … more →
SSIS 2012 Deployment Fail
wrote 1 day ago: No WiX Wednesday this week, owing to commitments in real life. Instead, here is something regarding … more →
QA Engineer (Performance Testing)- Glendale, Ca
wrote 1 day ago: Title: QA Engineer (Performance Testing) Duration: 6 Months (temp-to-perm) Location: Glendale Pay Ra … more →
SQL Server- Table Partitioning- TSQL Script- Details of a Partition in a database
wrote 1 day ago: USE [databaseName] GO SELECT SCHEMA_NAME(t.schema_id) AS SchemaName , OBJECT_NAME(i.object_id) AS Ob … more →
