SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

The School Year

It's August and for many people in the world that means that school will be starting sometime this month. My children have a little over two weeks left before they begin, with the mourning for the end of summer break already beginning. Some of us that work at a career for a living will also be starting school. People are pursuing advanced degrees, such as a PhD or MBA, while still managing a full time job, with their workload about to increase this fall as well. However most of us aren't in either of these situations, and we go to work each day, but come home and (hopefully) enjoy the rest of our lives with family, pursuing hobbies, or some other activity.

However many of us do have some leisure time that we could redirect to another endeavor. Working in technology can be a stressful, time consuming job at times, but it can also be a fairly easy job, physically. Many of us understand our environments and can often complete our jobs in a reasonable number of hours each week. It's also a job that often compensates us very well. However it's a field that demands regular skill improvement for success, security, and opportunity.

With that idea in mind, I wanted to ask you to think about the rest of the coming year. If you aren't overloaded at work, and you treat the next few months as the beginning of a school term, how would you answer this question?

What will you learn this semester?

Learning new skills can make your job easier (Powershell, administrators?). It might bring new opportunities or projects your way (Powerpivot/Powerview/Hadoop). It might even find you a new job, a job that suits you better in some way. If you blog about what you are learning, perhaps building a project, you might catch an employer's attention. Learning is almost never time wasted, if you have the time in your life. Consider taking on a small project, working your way through a Stairway series or book, or learning some new skill this fall.

This time of year is busy for me. I have eight more flights and events booked across the next few months, and a few new presentations to develop and practice. However I'm hoping to find a few minutes each day to work my way through a C# book and improve my skills in that area. I haven't built any front end software in years, apart from simple web interfaces, and I'd like to bone up some skills, which might bring new opportunities, but will also benefit my job where I need to create some content around the Deployment Manager product, in C#, and hopefully well done. No matter how it turns out, I'm sure I'll have learned something, and probably had some fun.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


Video and Audio versions

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Steve Jones

Windows Media Video ( 19.8MB) feed

MP4 iPod Video ( 23.1MB) feed

MP3 Audio ( 4.7MB) feed

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center

ADVERTISEMENT
SQL Toolbelt

Want to work faster with SQL Server?

If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

SQL DBA Bundle

Top 5 Hard-earned Lessons of a DBA

‘10 Tips for Efficient Disaster Recovery’ by Steve Jones. Prepare for any future disaster by reading Steve’s tips today.

Deployment Manager

Deployment Manager 2 is now free!

The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here.

Featured Contents

 

Sorting Months By Number (SQL Spackle)

Jeff Moden from SQLServerCentral.com

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead. More »


 

New SQL Monitor Custom Metric: Failed SQL Server logins

Press Release from Red-Gate

This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour. More »


 

SQL Saturday #235 New York City, NY

Press Release from SQLServerCentral.com

Come to SQL Saturday New York on August 17 for a day of free SQL Server training and networking. Some of the speakers at this event include Chris Bell, Ben DeBow, Ashish Sharma, and Hilary Cotter More »


 

The Big Data DBA

Additional Articles from Database Journal

Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards. More »

Question of the Day

Today's Question (by Igor Micev):

When does RangeI-N lock mode occur?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Locking.

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.

ADVERTISEMENT

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Naseer Ahmad):

Which option would we use to encrypt the definition of the view and prevent users of the database from seeing it?

Answer: ENCRYPTION

Explanation: Encryption is the correct answer. Schemabinding doesn't hide the definition and users of the database could still view the definition if TDE is enabled.

http://msdn.microsoft.com/en-us/library/ms187956.aspx


» Discuss this question and answer on the forums

Featured Script

Find Stored Procedures and Functions That Reference Certain Tables

Hakim Ali from SQLServerCentral.com

During the data discovery process on a database that I have inherited from another designer, I often have the need to determine all the stored procedures that interact with a certain table. For instance, I may need to look up all the stored procedures that insert records into a certain table. Or all the stored procedures that look up a certain view. Here is a code snippet that allows me to plug in the name of the table/view, and returns all the code objects (stored procedures, functions, triggers etc) that interact with that table/view. It returns the object type, the name of the object, and the code within that object broken up into more than one Code Sequence if the code is lengthy enough (longer than 4000 characters). You could, of course, also plug in the name of a code object to return other code objects that look up your searched object, for instance to find all the stored procedures that use a certain function.

Just replace the "search_term" in the code snippet with the name of the table/view/stored procedure/function etc that you want to search on.

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

Securty Trigger stroed procedure - Hi , I want to capturethe Audit Server Security Events , like if any one doing Create / Alter / Drop logins on server...

How to clear the MemToLeave area of SQL Server without restarting the service? - Hello All, Our developers implemented SQLCLR objects recently in our production SQL Server, and now due to the SQLCLR implementation, the...

System databases on an iSCSI LUN - Hi All, I am preparing to build a new SQL Server 2008 Enterprise server. The machine is very well equipped (Windows...

SQL Server 2005 : Business Intelligence

SSIS error - Hi All, I have installed the SQL server 2008 R2 version, when I tried to add Data flow task in SSIS...

Do I have to use a stored procedure in exe SQL task to use a parameter? - I want to set a conditional in an exec sql task based on the value of one of my ssis...

How to change the connection string of child packages in Execute Package task? - Hi Friends, I am tryting to execute multiple packages so i am using Execute Package Task to run the packages...

SQL Server 2005 : Development

Timetable query, using CASE - Hello I know this is a total newb question, but i have the following SQL: [code] SELECT FagNavn, adgangskrav, Ugedag, holdId, fagKode, CONVERT(CHAR(10),...

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. - Hello All I m not able to find this error Subquery returned more than 1 value. This is not permitted...

SQL Server 2005 : SQL Server 2005 General Discussion

View index not being used - Hi there, I have the following indexed view: CREATE VIEW [dbo].[campaignContacts] WITH SCHEMABINDING AS SELECT cs.campaignId, sc.contactId, COUNT_BIG(*) AS total FROM dbo.campaignSources cs INNER JOIN dbo.sources s ON s.id...

Trigger JOBS - how to trigger a job after completion of another job in sql server management studio 2005 I have two JOBS A...

Multiple Instances with Different IP Addresses and Same Port Number in SQL Server - Hi, We have one standalone SQL 2005 enterprise edition (64 bit) server. Its on windows 2003 server. We have multiple Ip address...

SQL Server 2005 : SQL Server Express

SQL 2005 on Server 2008 R2 not finding instances - Greetings all, New to this site and it looks like just the place I need to ask about this problem. Little...

SQL Server 2005 : SQL Server 2005 Integration Services

concatenating date and time field - The OledbSource has a date field and time field. The OleDbDestination has the field as a datetime. Do I have...

delete files using ssis - Hi...I want to build an SSIS package that deletes the log files whose names are like Package20081002.txt. The names of...

SQL Server 2005 : T-SQL (SS2K5)

help with joins - i have 2 table with 1 to many relation table1 hid ,refid cid 500 4 1200 501 4 1200 table2 id description refid...

Primary Key - Hi All, How many primary keys can i create in a table. I mean total number of primary keys in a...

SQL Server 7,2000 : Administration

Trying to attach MDF Server 2000 with error I/O error (torn page) detected during read at offset - Hello, I have a MDF file that has a torn page error that I recently inheritied. The old database server...

SQL Server 7,2000 : SQL Server Newbies

attempting to recreate complex "multi-layer" Access queries in SSMS - Please excuse me if Im not usung the right terminology. I am a SQL Server newbie and have a basic...

SQL Server 7,2000 : T-SQL

How to capture a SP embedded in a bespoke app - Hi, I'm looking after an application that runs a stored procedure created within the source code of the app. I'm guessing that...

SQL Server 2008 : SQL Server 2008 - General

Right outer Join??? - I know I'm lost somewhere here but I thought this would get me all client in Rday_All_clients even if a...

Backup Set List Not Populating - I have posted this on Amazon's Developer Forum, but I have also seen this happen at other times. I have a...

Can SSIS tell a batch file to move on before the SSIS package completes? - Hi, Question: Can I run a series of SSIS packages from a batch file where each package has 10 steps, and...

Using extended events to capture sort warnings and hash warnings - Hi I have just downloaded the extended events gui for sql2008. Can anybody point me to any articles on how to set...

Tempdb tables two months old - Hi All I run the following query to get all tempdb tables: [code="sql"]SELECT * FROM tempdb.sys.sysobjects WHERE name LIKE '#%' ORDER BY crdate[/code] I can see...

Query an Acceess Table in SSMS - Heres my scenario. I have an access table called Innovative in an access database. While on the server i can query...

Question in SSIS package, data flow task..... - Hello, I am not sure how to proceed here... I will try to expline my situation clear.... I need to write a...

WITH (NOLOCK), allows dirty reads. - Hello, [size="1"]I am aware the the WITH (NOLOCK) hint should be avoided, that is not the question. Also I am aware...

Login Creation - Hi Team, While creating a new login, Effective tab is missing in securables window, Please suggest..

Generate a day date according to existing month+year+daydiff - im using sql 2008. i got this 5 columns: StartMonth,StratYear,EndMonth,EndYear,DaysBetween i dont have the day of these dates and that's what im trying...

Query execution time in Milisecond - Hi I have one problem statement to create sq. query. For the solution i have created three different queries, one using...

Bizarre Database Mail problem - I'm having a very strange problem related to Database Mail. I wonder if anyone can help me with. I have a...

Autoshrink enabled on a database - I understand that it is highly undesirable to have autoshrink on a database, since this would cause severe fragmentation. I have...

Change query from sql 2000 to 2008 - Hi, I want to modify the below query which exists in 2000 to sql 2008. Can u please help me? select * FROM...

How to separate the address? - Hi Friends, [code="sql"] Create Table Adrtbl (Address varchar(80)) Create table SpltAdr (Prefix char(2),StreetName varchar(50),StreetType varchar(10)) GO insert into Adrtbl select 'WESTLAKE DR' union select 'W BLK BROWN...

checking the setup of your discs - I need to check what disc configuration we use to store our log files and data files. We use a...

ADO NET Source works perfectly within BIDS but getting error in a SQL Agent Job - Hi, I have a SSIS Package with a ADO NET SOURCE for capturing data from MS Access DB which is in...

openquery single quote - Hi All, I have an application which automatically generates SQL - To connect my application to my SAAS database I am...

Catch text before symbol - Hi geniuses, consider: [code="sql"]create table #mytable ( Value varchar(50) ) INSERT INTO #mytable (Value) SELECT 'First.Second'[/code] [b]I need to isolate what's before the symbol: '.'[/b] I was...

Question about user and login - Hello I created new login and new user to exists login. Next step is log to database with created username database...

How To DISTINCT COUNT with Windows Functions (i.e. OVER and PARTITION BY) - SQL 2012 Reference = http://msdn.microsoft.com/en-us/library/ms175997(v=sql.110).aspx I'm trying to get a unique count of rows in a child table in a multi-table join...

"Failed to retrieve data for this request" error when trying to add feature - Hi everyone, I wish to check if anyone has encountered this similar issue. I am on Windows Server 2003 SP2 and...

Stored Procedure (or) SQL Script Output to Text File - Hi All, I am having a Stored Procedure Or SQL Script to be attached to Job Scheduler. When this Stored...

SQL Server 2008 : T-SQL (SS2K8)

String Manipulation - Hello Everyone I have a strange thing that I am trying to code for, and I am almost there, but I...

update records based on condition - hi i have table , which can have millions of rows. Member primarycondition primaryintensity secondarycondition secondaryintensity M2345 hf 1 M2345 COPD 1 M2345 CAD 1 M2345 dia...

Executing an SP in a new SPID? - Hi all, I'm coding a stored procedure which will be the control mechanism for a series of ETL subprocesses. This control...

Grouping by columns to create single record - I am in a time crunch, many things on my plate today, and I just can't seem to get this...

CTE - How do I nested common table expression?

Find potential locks caused by joined queries - I have an application that is slowing down under a fairly heavy load and I believe some of my relational...

query to get the size of all indexes in a database - Hi Friends, Is there any query to get the size of all indexes in a database? Let us assume a database...

how to store result at variable? - Hi, create proc sp_temp --@temp varchar(10) as begin declare @Result varchar(5) select COUNT(*) from #temptable end this simple SP working fine.. I want store the result in one...

sp_executesql MAXDOP - Just trying to test the affect of MAXDOP = 1 inside a query executed by sp_executesql within CRM. The query itself...

how to import excel file into sql server using identity column - I have an excel file with email ids as one column.i want those email ids into the database along with...

select distinct rows - hi my stored prc return value slike this rule date no abc1 03/17/2003 23 abc1 04/15/2004 45 abc2 04/43/2009 120 i need to display only 1...

SSIS ( cannot able to change datatype column using datatype conversion...... - Hi, Source: multiple text file Requirement: 1. Define age columns as small integer. 2. Convert gross column from $ 667 00 to 667.00...

Need Help TSQL Code. - I have source file with column Full Name Jim k Smith Robert K Lin Chris Tim and My destination has FirstName and LastName I want to parse...

Create sum closest to an integer - Hi, I need to create a function that will check an int column from a table and has to generate the...

SQL Server 2008 : SQL Server Newbies

Easy (I hope) join question - Hi, I have two tables with many fields in them. I am only interested in a few of the fields, and...

TempDB Full...!! - Hello Masters, My TempDB full..!! Its utilising almost 400% more disk space than its assigned..! How can I free disk space...

Can someone tell me what is wrong in this query: I get error Msg 102, Level 15, State 1, Line 1 Incorrect syntax near - insert [User_Id], [Customer_Id], [User_Name], [Preferred_Name], [Email], [Mobile_Phone_1], [Mobile_Phone_2], [Mobile_Phone_3], [Phone_1_Status], [Phone_2_Status], [Phone_3_Status], [Password], [REMINDER_QUESTION], [REMINDER_ANSWER], [Registration_Date], [Registered_By], [Approval_date], [Approved_by], [Last_UpdateD], [Last_Updated_By], [Last_Sign_On_Tel], [Last_Sign_On_SMS],

need help with applying function within Query - Hi all Its my first post here! Glad to be here.Hopefully someone can help me with the following. If you look at...

SQL Server 2008 : Security (SS2K8)

Check_expiration option - Hello friends, I want to create a SQL db user to be dedicatedly used by application only. I am providing...

SQL Server 2008 : SQL Server 2008 High Availability

Very slow for running Query in Standby database? - Hi. Log shipping setup on of the table total Records count 1228976 in standby database, user have read access and using...

DR Testing Question - Hi Guys, I am currently in the planning process of a DR testing(Mirroring Failover) and I need some clarification for couple...

SQL Server 2008 : SQL Server 2008 Administration

Replication or Mirroring - We have an application that is starting to gain more users and is becoming more "critical" that it stay up....

unable to connect with default instance - Hi, I have installed sql server 2008r2 enterprise edition on my system.i have got the following errors such as 1) unable to...

changing disk arrays for db's but keeping same drive letters! - We run in Amazon EC2 but I am sure the principal is the same. Currently the system db's are on C:\...

Error while installing - Hi all here i am trying to install the sql server in our server but finally it is showing some error...

Need a blocking script with specific details - Hello All, I am looking for a script that will give me these details. 1) spid 2) Total number of spids...

Career : Certification

Can I able to write 70-448 after JULY 2013 - Hi Folks, I have Passed 70-432 and 70-433 MCTS Exams. Also I have passed 70-451 (MCITP). Now am planning to write 70-448...

Programming : Powershell

Insert xml data into SQL server via SqlBulkCopy with powershell (casting error) - I tried to strip down this example to make it as terse as possible so it would be easy to...

SQLServerCentral.com : Anything that is NOT about SQL!

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

SSRS - How to create height dynamically for bar charts - Hello, I have earlier calculated the height for all my bar charts dynamically by specifying the Maximum value for the y...

Reporting Services : Reporting Services 2005 Development

BIDS problem working with parameters - When working with parameters in SSRS 2005 I am having a problem where the internal flag that is checked first...

Database Design : Design Ideas and Questions

User Access Puzzle - We have a list of employees, and want to allow users of our system to be able to access a...

Database Naming Convention - I have seen lots and lots of commentary and comments about naming SQL Server database objects. But what about the...

Data Warehousing : Integration Services

Reverting To BCP for DTS package instead of migrating to 2008? - Would anyone out there convert old DTS packges on SQL2000 to BCP instead of migrating them to 2008R2 SSIS packages?...

Automatically Mapping Flat File Sources Data types to Destination - Is there anyway to automatically map a flat file sources data types to the ole DB destinations data types? I'd...

Data Warehousing : Analysis Services

DAX - I trying to create a type of inverse filter using DAX. For Ex: [b][u]Filter Table[/u][/b] [u]Column1[/u] A B C If a user filters by A, then...

To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com