Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

UPPER() function in SQL Server

UPPER():- This function is used to convert the value of a column to upper case.

 Syntax:

   SELECT UPPER(string)

OR

Select UPPER(Column name) from tablename

For example,

  SELECT UPPER('Vivek')

Result:


   VIVEK



Read more

0 comments, 238 reads

Posted in Vivek's SQL Notes on 14 August 2014

AVG() function in SQL Server

Avg():- This function is used to get the average value of a numeric column

Syntax:-


      SELECT AVG(column_name) FROM table_name


In this article, we are going to use the following table for some examples:-

CREATE TABLE [dbo]. [Employee](
[Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,
[EmpNumber] [nvarchar](50) NOT…

Read more

0 comments, 110 reads

Posted in Vivek's SQL Notes on 14 August 2014

LOWER() function in SQL Server

LOWER():- This function is used to convert the value of a column to lower case

 Syntax:-

 Select LOWER (string)

 
 or
 

 SELECT LOWER(column_name) FROM table_name

For example,

SELECT LOWER('Vivek Johari')

Result:-

vivek johari


Read more

0 comments, 86 reads

Posted in Vivek's SQL Notes on 14 August 2014

LEN() function in SQL Server

LEN():- This function is used to get the length of the given string value.

  Syntax:-


    Select len (stringvalue)

  For example,

    Select len('Vivek Johari')

   Result:-

   12

Read more

0 comments, 92 reads

Posted in Vivek's SQL Notes on 14 August 2014

Substring() function in SQL Server

Substring():- This function is used to return the specified number (third argument "len") of characters from a given string(first argument) from the start position as specified as the second argument.

Syntax:-

   Select  SUBSTRING ( expression ,start , length )

For example,

       Select  SUBSTRING ( 'kingmaker' ,1 , 4…

Read more

0 comments, 75 reads

Posted in Vivek's SQL Notes on 14 August 2014

LTRIM() function in SQL Server

LTRIM ():- This function is used to get the string after the removal of leading blank spaces.

Syntax:-

LTRIM ( character_expression )


For example:-

Select LTRIM  ('  Vivek Johari')

Result:-

Vivek Johari (without blank spaces on left side)


Read more

0 comments, 74 reads

Posted in Vivek's SQL Notes on 14 August 2014

SQL Server UG in Vegas August 2014 Meeting

 

Another Great meeting and topic is coming to the folks in Las Vegas.  This month we have had the luck of finding Mike Fal (blog | twitter) step up and fill our speaker void.

Yes, it happens to be the second Thursday of the month already.  Being… Read more

0 comments, 72 reads

Posted in SQL RNNR on 14 August 2014

One of Those Must Read Books – The Cuckoo’s Egg

I was reading a book about network security monitoring and it mentioned The Cuckoo’s Egg by Cliff Stoll. Stoll’s book has been around for a long time, and it’s considered a classic book with regards to information security. If you’re not familiar with it, it’s the story of a gentleman… Read more

1 comments, 84 reads

Posted in Databases – Infrastructure – Security on 13 August 2014

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 82 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

SQL Server for VM Admins vBrownBag Webinar

Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL Server Virtualization for VM Admins“. The #vBrownBag webinar series covers a number of VMware-related topics, and I am very pleased to be able to present my session… Read more

0 comments, 79 reads

Posted in Technobabble by Klee from @kleegeek on 13 August 2014

Tableau Conference Is Bigger Than PASS Summit

I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe,  I was astounded to see that the Tableau Conference is bigger than the PASS Summit. Both are in Seattle (different dates), and the prices look to be similar ($1495 is the number I saw… Read more

2 comments, 100 reads

Posted in SQLAndy on 13 August 2014

Max() function in SQL Server

Max():- This function gives the maximum value of the selected column

Syntax:-

Select Max (col1) from table_name


In this article, we are going to use the following table for the examples:-

CREATE TABLE [dbo]. [Employee](
[Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,
[EmpNumber] [nvarchar](50) NOT NULL,
[EmpFirstName] [nvarchar](150)…

Read more

0 comments, 89 reads

Posted in Vivek's SQL Notes on 13 August 2014

RTRIM() function in SQL Server

RTRIM():-This function is used to get the string after the removal of all trailing blanks.

Syntax:-

RTRIM ( character_expression )

For example:-

Select RTRIM('Vivek Johari  ')

Result:-


Vivek Johari (without blank spaces on Right side)


Read more

0 comments, 94 reads

Posted in Vivek's SQL Notes on 13 August 2014

AND and OR Operator in Sql Server

And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions are specified. In case of "AND" all the conditions must be true and in case of "OR" any of the condition must be true.
In this article, we are…

Read more

0 comments, 85 reads

Posted in Vivek's SQL Notes on 13 August 2014

T-SQL Tuesday #57: SQL Family and Community

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that wonderful monthly blogging party started by Adam Machanic (Blog | @AdamMachanic). The intent is to get the entire SQL Community together on a monthly basis to blog about…

Read more

0 comments, 122 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

Building a Virtual Machine within Azure (IaSS) – Improvements !

Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows azure portal over the last couple of months.

I had to create a VM in Azure to do some testing, and this time I decided to try out the… Read more

0 comments, 5,497 reads

Posted in SQLSailor.com on 12 August 2014

MS14-044–Security Alert for SQL Server

I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL Server. Here’s the bulletin:

MS14-044

There are QFE and GDR patches for versions since 2008, but you need to read carefully to determine which one to install on your systems. Read more

0 comments, 87 reads

Posted in The Voice of the DBA on 12 August 2014

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User Group at 6:30pm.  The abstract for my session is below.  I hope you can make it!

Modern Data Warehousing

The traditional data warehouse has served us well for many years,… Read more

0 comments, 135 reads

Posted in James Serra's Blog on 12 August 2014

T-SQL Tuesday #57 – SQL Family and Community

Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday.  TSQL Tuesday is a recurring blog party that occurs on the second Tuesday (most generally) of the month.  This event was the brainchild of Adam Machanic (Blog |… Read more

1 comments, 93 reads

Posted in SQL RNNR on 12 August 2014

Snippet Alert: Useful dates (eom, bom, etc)

Common date values you may need to reference that you may not want to write from scratch each time.

language-sql  
$CARET$declare @Date date = getdate()
select  
    previous_month_bom =    dateadd(month, datediff(month, 0, @Date) - 1, 0) --previous_month_bom
    ,previous_month_eom =   dateadd(day, -1, dateadd(month, datediff(month, 0, @Date), 0)) -- previous_month_eom 
    ,bom =                  dateadd(month,…

Read more

0 comments, 93 reads

Posted in BIT Barbarian on 12 August 2014

Newer posts

Older posts