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.
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.
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 »
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
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.
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.
View index not being used
- Hi there,
I have the following indexed view:
CREATE VIEW [dbo].[campaignContacts] WITH SCHEMABINDING
SELECT cs.campaignId, sc.contactId, COUNT_BIG(*) AS total
FROM dbo.campaignSources cs
INNER JOIN dbo.sources s ON s.id...
- how to trigger a job after completion of another job in sql server management studio 2005
I have two JOBS A...
How to separate the address?
- Hi Friends,
Create Table Adrtbl (Address varchar(80))
Create table SpltAdr (Prefix char(2),StreetName varchar(50),StreetType varchar(10))
insert into Adrtbl
select 'WESTLAKE DR'
select 'W BLK BROWN...
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,
[code="sql"]create table #mytable
INSERT INTO #mytable
[b]I need to isolate what's before the symbol: '.'[/b]
Question about user and login
I created new login and new user to exists login. Next step is log to database with created username database...
- 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
i have table , which can have millions of rows.
Member primarycondition primaryintensity secondarycondition secondaryintensity
M2345 hf 1
M2345 COPD 1
M2345 CAD 1
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...
how to store result at variable?
create proc sp_temp
declare @Result varchar(5)
select COUNT(*) from #temptable
this simple SP working fine.. I want store the result in one...
- Just trying to test the affect of MAXDOP = 1 inside a query executed by sp_executesql within CRM. The query itself...
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.