Career: an individual's journey through learning, work, and other aspects of life.
Vocation: an occupation to which a person is specially drawn or for which he or she is suited, trained, or qualified.
Which one describes your current employment situation? How do you feel about the technical work you do? A career is a good thing, and I hope that you all have long, successful careers, I hope you continue to learn and maintain a balance between work and your life outside of your job.
However a vocation is what I'd hope drives you forward. You find some endeavor that you are drawn towards, and at which you have some skill at performing. As much as I never planned to be a technical writer, I find that I am really drawn to it, and I enjoy the work quite a bit. I'd say the same thing about speaking and presenting to groups of technical workers. My employment is more of a vocation, and certainly much more than "just a job."
As you go to work, accomplish tasks and finish projects, think about what you like and don't like. Think about whether you look forward each day to the challenges you face or you dread each hour. If it's the latter, then I hope you are making plans to change something. Find a new employer or position. Life is short and you need to remember that you'll spend a lot of your time at work. Make what you do a vocation and work becomes an exciting piece of your life that enriches your time here.
24% of devs don’t use database source control – make sure you aren’t one of them
Version control is standard for application code, but databases haven’t caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out…
On May 31, 2014 SQL Saturday is coming to Redmond, Washington. Come for a free day of SQL Server training and networking, the schedule currently features tracks on T-SQL, SSIS, Backup & Recovery and more. Register while space is available. More »
Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to querying columns with the collation set to SQL_Latin1_General_CP1_CS_AS. More »
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously... More »
Question of the Day
Today's Question (by Andy Warren):
Pop quiz hot shot - say you're on a bus going 50 miles per hour when the driver asks you for the ranges of the exact number data types in SQL Server. Your eyes glaze, who can remember that stuff? He says, ok hotshot, how about this - tell me the smallest exact number integer data type that can't support a negative number and I'll stop the bus and buy you breakfast.
Can you answer the question, stop the bus, and have a nice omelette?
Note - don't worry about the spelling/abbreviation used for the data types in the answers.
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: Data Types.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.
Assume you have a table "Transactions" in the database "Test". The table "Transactions" has CDC enabled on it. Now we shall create a DDL Trigger on DROP_TABLE event. The trigger code is as follows:
CREATE TRIGGER PreventDrop ON DATABASE
IF EXISTS ( SELECT *
WHERE name = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)',
AND is_tracked_by_cdc = 1 )
What happens if you drop the table "Transactions" ?
Answer: Trigger will not rollback the transaction and the table is dropped
DDL triggers fire only after the DDL statements that trigger them are run. So the table is already dropped when the trigger is fired but it is not committed. The event which fired the trigger and the trigger come under the same transaction.
As the table is already dropped by the time the trigger is fired, the entry of that table is deleted from sys.tables.
So, the statement
if exists( select * from sys.tables where name = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)', 'varchar(100)') and is_tracked_by_cdc=1)
will not return any rows and the rollback command will not even run.
A simple rollback statement in the trigger code without the if exists statement would have stopped the drop though.
It's preety easy. Just copy and paste it in to the ssms window and run the script. The result will speak for itself. After copying the results, run the last portion (to delete the temp tables) again and make sure they are deleted.
T- SQL Query
I have a Table 'A' where column X is of type XML.
Following is Column X value
Parse XML Data to Table format
- Hi friends,
declare @xml table (xmldata xml)
insert @xml select
<field name="vehicleno" fieldType="int" fieldSize="">
div.biz-page-subheader li > span.i-phone-biz_details-wrap...
Querying XML from SSMS
I have an xml document that (for this example) I've simplified to look like this:
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
Odd Results from an Indexed JOIN Column
- Hello there! Starting off with some DDL...
CREATE TABLE #AgentSession(
[sessionId] [int] IDENTITY(1,1) NOT NULL,
[dirSrvSessionGuid] [uniqueidentifier] NOT NULL,
[serverId] [int] NOT NULL,
problem with Sql _Variant in the code
- HI All ,
Below is my script:
/****** Object: StoredProcedure [Neg].[UsersCreateStaticsGet] Script Date: 03/27/2012 09:47:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
How to convert the below statement into SSRS expression
I have an active report code where
this.lblJulCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -3) + " Meal Count";
this.lblSepCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -2) + " Meal Count";
I am converting this...
group by clasue in mdx
- Hi Friends i have small doubt in mdx query.
table having data like below
table name : patieninformation
pn prcode dos Expected Payment
MS0000003 PT001 1/2/2013 29.72 0
MS0000003 PT001 1/21/2013 57.1 0
MS0000003 PT002 6/7/2013 26.69...
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.