SqlServerKudos

Community

1
kudos

Kudos

The SQL Server MasterClass Experience | AdaTheDev

published 31 days, 6 hours, 51 minutes ago posted by

AdaTheDev 40 days, 10 hours, 41 minutes ago

The SQL Server MasterClass Experience | AdaTheDev

SQL Server MasterClass 2010 was a very high quality, one day event presented by Paul S. Randal and Kimberly L. Tripp - not that they need any introduction of course. In fact if you don't know of them, then perhaps you should close down your SSMS window and switch off your machine - after reading my blog of course :). Maybe uninstall SQL Server too... The A-Team With two of the best SQL Server trainers in the industry offering a packed schedule of sessions, it was an... (more)

category: Community | clicked: 0 | comment | | source: www.adathedev.co.uk

tags: DBA, SQL, SQL Server, SQLServer

1
kudos

Kudos

Makati Condo

published 32 days, 6 hours, 51 minutes ago posted by

kishang 41 days, 8 hours, 20 minutes ago

Offers well established real estate properties in the Philippines such as lots,houses,condos, and commercial - UmbrellaOnline.com (more)

category: Community | clicked: 0 | comment | | source: www.umbrellaonline.com

tags: code, condos

1
kudos

Kudos

Ready To Spark SQL Server Study Group Meetups!

published 54 days, 8 hours, 33 minutes ago posted by

http://marlonribunal.myopenid.com/ 63 days, 14 hours, 27 minutes ago

Ready To Spark SQL Server Study Group Meetups!

tags: sql server study groups It’s been a while since my last SQL-related post (re #SQLSat44). So here goes another one. It’s not about SQL Server per se but I hope that this will encourage all SQL Server pros to get together and become rock stars in their own SQL Server battlefields. Almost a year ago I decided to take my first ever Microsoft Certification Exam. I did struggle on the study process because I have to juggle between tasks and responsibilities. Time management has always been an issue whe... (more)

category: Community | clicked: 0 | comment | | source: dbalink.wordpress.com

tags: microsoft certification, SQL Server, study group

2
kudos

Kudos

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!! - SQL Server News

published 75 days, 10 hours, 7 minutes ago posted by

ashishgilhotra 85 days, 6 hours, 51 minutes ago

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!! - SQL Server News

So what is so exciting about the SQL Server 2008 R2 Release? Well, along with plenty of BI features and enhancements, there is a tiny cute feature that I am sure all of us will appreciate a lot. The product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have got a growing SQL Server Express database that is close to the 4 GB Limit, hurry, upgrade to R2 Express. (more)

category: Community | clicked: 0 | comment | | source: beyondrelational.com

1
kudos

Kudos

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

published 78 days, 10 hours, 21 minutes ago posted by

pinaldave 86 days, 19 hours, 9 minutes ago

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions. The query for this is very simple. It uses two DMVs and created following quick script for the same. SELECT session_id, TEXT FROM sys.dmexecconnections CROSS APPLY sys.dmexecsqltext(mostrecentsqlhandle) AS ST While working with DMVs if you ever find any DMV has column with name sqlhandle you can right away join that DMV with another DMV sys.dmexecsqltext and can get the tex... (more)

category: Community | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Get A Second Shot On Microsoft Exam

published 83 days, 10 hours, 41 minutes ago posted by

http://marlonribunal.myopenid.com/ 92 days, 20 hours, 49 minutes ago

tags: exam voucher. prometic, free second shot voucher, mcp, MCTS There are many reasons why people do not take the Microsoft Certification Exams. Let’s face it. Some people do not believe that taking these exams and passing them do not add value to their career. Let us not talk about these people right now. Let’s talk instead about the people who actually believe in the value that these exams can add to their worth as professionals – about people who are continuously after the pursuit of perfecting the... (more)

category: Community | clicked: 1 | comment | | source: dbalink.wordpress.com

tags: mcitp, mcts, microsoft exam, second shot voucher

2
kudos

Kudos

Report selection in parameter toolbar - Some Random Thoughts

published 84 days, 10 hours, 46 minutes ago posted by

jacobsebastian 93 days, 7 hours, 46 minutes ago

Report selection in parameter toolbar - Some Random Thoughts

The MSDN forum has been the inspiration for most of my blogs, but in all those cases, I was sure that I could attain the end result and my blogs were usually a graphical step by step depiction of what needs to be done, so that I could post it as an answer to the question. But this blog is quite different, I almost wrote a no saying that it is not possible. And that was when I decided to give it a try before replying No :) (more)

category: Community | clicked: 1 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

1
kudos

Kudos

The SQLBits VI Experience | AdaTheDev

published 99 days, 11 hours, 57 minutes ago posted by

AdaTheDev 103 days, 12 hours, 34 minutes ago

I had high expectations about SQLBits VI and it certainly lived up to it! Not only did it have great speakers, who really know their stuff and have an effortless way of getting the information across, but it was also free. So it goes without saying that it was a popular event. There were 4 sessions going on at any one time with a theme of performance and scalability and plenty of choice across DBA, Dev and BI areas. It did mean some tough decisions had to be made between which ones to attend! (more)

category: Community | clicked: 1 | comment | | source: www.adathedev.co.uk

tags: SQL Server, SQLBits

1
kudos

Kudos

SQL Saturday #44 – First In California!

published 138 days, 14 hours, 47 minutes ago posted by

http://marlonribunal.myopenid.com/ 147 days, 23 hours, 28 minutes ago

2010tags: free training, socal, SQL Server, sqlsat44, sqlsaturdayCALL For Speakers The SQL Saturday event in Southern California is finally here! Call for Speakers is officially open. According to the official record, this is the first ever SQL Saturday event in California and the first one set up since the transfer of SQLSaturday to PASS. I am just happy to be part of this event for the values I get from attending and organizing and for its place in history (PASS’ history, at least). If you plan to a... (more)

category: Community | clicked: 0 | comment | | source: dbalink.wordpress.com

tags: free training, PASS, SQL Saturday, SQL Server, sqlsat44

1
kudos

Kudos

The Benefit Of Attending User Group Meeting

published 138 days, 14 hours, 47 minutes ago posted by

http://marlonribunal.myopenid.com/ 148 days, 10 hours, 15 minutes ago

The Benefit Of Attending User Group Meeting

2009tags: BI, Business Intelligence, free training, gain knowledge, livemeetings, PASS, professional networking, SQL Server, sql server dba, user groups, Virtual User Groups, virtualization, women in technology I want to be consistent in attending User Group Meetings on monthly basis. Unfortunately, due to conflict of schedules, I haven’t been able to target consistency. The last meeting I attended was at Orange County SQL User Group last month (August). I planned to attend South Bay .NET User Group S... (more)

category: Community | clicked: 8 | comment | | source: dbalink.wordpress.com

tags: community, sql pass, Training, user group

1
kudos

Kudos

A SQLSaturday We Can Call Our Own

published 138 days, 14 hours, 47 minutes ago posted by

http://marlonribunal.myopenid.com/ 148 days, 11 hours, 16 minutes ago

2010tags: socal, sql saturday, SQL Server, SQLSat, Training At last, we have just started the real work that it is involved in organizing a SQLSaturday event (see related post). Earlier today our group had a conference call for preliminary planning for the event. A lot about logistics, sponsorships, swag, funds and others were discussed. We are now slowly seeing the fruit of this effort we all started back in October last year. SQLSaturday is now coming to the Southern California Region. There have be... (more)

category: Community | clicked: 2 | comment | | source: dbalink.wordpress.com

tags: sql pass, sqlsat44, SQLSaturday

2
kudos

Kudos

Ozziemedes on SQL Server: Three Things That Got Me Here

published 174 days, 19 hours, 36 minutes ago posted by

http://ozziemedessql.blogspot.com/ 184 days, 4 hours, 43 minutes ago

Ozziemedes on SQL Server: Three Things That Got Me Here

I have been tagged by Josef Richberg (@SQLRunner on Twitter) to blog on a meme covered by several SQL Server and .NET professionals since the concept got started around the beginning of January. Apparently being tagged means I must continue the meme, so… in three movements… here we go. Lego As a kid, my parents bought me a few bits and pieces of Lego. The first 10 minutes of any session spent with a new Lego kit would be spent following the assembly instructions to create the train, car, castle, et... (more)

category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com

tags: Things That Got Me Here

1
kudos

Kudos

Ozziemedes on SQL Server: Goals, Themes, Memes and Mayhem

published 187 days, 20 hours, 32 minutes ago posted by

http://ozziemedessql.blogspot.com/ 197 days, 15 hours, 58 minutes ago

Ozziemedes on SQL Server: Goals, Themes, Memes and Mayhem

Okay… still not the promised blog entry on doing nifty stuff with table metadata. Another response to someone else’s blogging. I just can’t help myself… call me a sucker for the #SQLPASS community, now that I know it exists. Short, sharp and shiny will this be. There’s a meme for 2010 goal-stating blogs doing the rounds on SQL Server MVP blogs at the moment. Luminaries such as Brent Ozar (@BrentO), Jeremiah Peschka (@peschkaj), Andy Leonard (@AndyLeonard), Kevin Kline (@kekline), and a host of othe... (more)

category: Community | clicked: 2 | comment | | source: ozziemedessql.blogspot.com

tags: @GregLow, @Rob_Farley, Goals, MCT, Memes, mvp, SQL Server, Tag, Themes

1
kudos

Kudos

Buck Woody : The Database Design Process

published 188 days, 20 hours, 37 minutes ago posted by

http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 13 minutes ago

Buck Woody : The Database Design Process

I need your help. I know how I create databases, and I’ve watched a lot of other data professionals follow their own processes for that, but I want to know how YOU do it. I’ve written about the process I follow for a complete database design on InformIT (use the "Next" button at the bottom of these to see them all). Beyond starting with the business requirements and REALLY hammering that out, here is the general outline I use: 1. Pull out the nouns from the business requirements (“Client”, “... (more)

category: Community | clicked: 0 | comment | | source: sqlblog.com

tags: @BuckWoody, Data Design, Data Modelling, microsoft, SQLBlog

1
kudos

Kudos

Ozziemedes on SQL Server: A Brief Diversion on Database Design

published 188 days, 20 hours, 37 minutes ago posted by

http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 43 minutes ago

Ozziemedes on SQL Server: A Brief Diversion on Database Design

My promised follow-up on the sys.tables post is still in the skunk works. I got distracted by an interesting post by Buck Woody of Microsoft over on his Blog on SQLBlog.com. The questions he posed are as follows: 1. What process do you follow? 2. How important are the business requirements? 3. What tool do you use to create the design, do you need it to diagram, do you even care about diagrams? 4. What’s your biggest pain-point about designing? Not with SQL Server, mind you, just the designing part... (more)

category: Community | clicked: 1 | comment | | source: ozziemedessql.blogspot.com

tags: @BuckWoody, Comment, Data Modelling, Database Design, Process, SQL Server, Tools

2
kudos

Kudos

Ozziemedes on SQL Server: Metadata Basics – The Great DBA Koan

published 196 days, 21 hours, 12 minutes ago posted by

http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 47 minutes ago

Ozziemedes on SQL Server: Metadata Basics – The Great DBA Koan

So… you just got your new shiny SQL Server DBA Deputy’s badge, and moved your crap over to a new desk, next to the resident SQL Expert in your office, all keen for the Great Imparting Of Wisdom (GIOW), and he’s handed you a diagram full of coloured regions, annotated boxes and connecting lines. “First things first, get yourself up to speed with the system catalog for SQL Server,” he says, then turns back to his own screen to fix whatever just got broken for the third time today. About now, many young D... (more)

category: Community | clicked: 1 | comment | | source: ozziemedessql.blogspot.com

tags: Metadata, MSDB, MSSQL, SQL Server, System Catalog, User Schema

2
kudos

Kudos

Ozziemedes on SQL Server: Mining Metadata

published 196 days, 21 hours, 12 minutes ago posted by

http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 51 minutes ago

Ozziemedes on SQL Server: Mining Metadata

One thing that I have found especially useful in my career working with databases is keeping up with the structure of metadata available in system databases, and with metadata stored in user database system catalogs. For those of you unfamiliar with the term, metadata is often described as “data about data”. I prefer a slightly less simplistic explanation: “Metadata describes the format, structure and behaviour of data and code in computer systems.” The first definition catches situations where metada... (more)

category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com

tags: Definition, Metadata, MSSQL, SQL Server

1
kudos

Kudos

The reviews of Expert Cube Development book

published 309 days, 6 hours, 11 minutes ago posted by

sa 319 days, 4 hours, 18 minutes ago

The reviews of Expert Cube Development book

I already talked about the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote with Chris and Alberto. We found several posts around the blogosphere and I'd like to keep track of them - I'll try to update this post whenever we found new entries. Feel free to add links in the comments. Some of the reviews are not in English, but you can easily translate them in 2009!Hilmar BuchtaFrancesco De Chirico (Italian)FrédéricPhil MilnerAshok KumarThomas IvarssonAdam JorgensenFran... (more)

category: Community | clicked: 0 | comment | | source: sqlblog.com

tags: Book Review

1
kudos

Kudos

SQL Quiz: My relative path to Geekdom

published 319 days, 6 hours, 56 minutes ago posted by

sa 326 days, 6 hours, 20 minutes ago

I got tagged in another SQL Quiz going around, this time by Mr. Denny (Blog/Twitter). I tried to come up with some kind of witty title for this post and as usual I lacked the ability. My wife recommended using a story like the guy on The Guardian, Emily Thomas: How does Jake Fischer become a guy who wants to jump out of helicopters? Jake Fischer: I killed a couple guys and had to get out of Dodge. Emily Thomas: You're lying. Jake Fischer: There is that possibility. Emi... (more)

category: Community | clicked: 8 | comment | | source: sqlblog.com

tags: SQL Quiz

1
kudos

Kudos

Come to the PASS Summit

published 320 days, 7 hours, 1 minute ago posted by

sa 330 days, 4 hours, 23 minutes ago

"What's the big deal about the PASS Summit, Andy?" Allow me tell my story (again): "Hello. My name is Andy Leonard, and I am an accidental database professional." "Hi Andy." I jumped the fence from applications developer to database person in 2003. I thought I understood databases. I could write queries, design tables, build stored procedures, etc. And then I was standing nearest the server when my team decided to replace the SQL Server person. Bam! Instant SQL Server guru... right? WRONG! Yes, I had... (more)

category: Community | clicked: 0 | comment | | source: sqlblog.com

tags: Conference, PASS Summit 2009

Welcome!

Community

The SQL Server MasterClass Experience | AdaTheDev

Makati Condo

Ready To Spark SQL Server Study Group Meetups!

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!! - SQL Server News

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

Get A Second Shot On Microsoft Exam

Report selection in parameter toolbar - Some Random Thoughts

The SQLBits VI Experience | AdaTheDev

SQL Saturday #44 – First In California!

The Benefit Of Attending User Group Meeting

A SQLSaturday We Can Call Our Own

Ozziemedes on SQL Server: Three Things That Got Me Here

Ozziemedes on SQL Server: Goals, Themes, Memes and Mayhem

Buck Woody : The Database Design Process

Ozziemedes on SQL Server: A Brief Diversion on Database Design

Ozziemedes on SQL Server: Metadata Basics – The Great DBA Koan

Ozziemedes on SQL Server: Mining Metadata

The reviews of Expert Cube Development book

SQL Quiz: My relative path to Geekdom

Come to the PASS Summit

Open ID Login

Standard Login

Forgot Password?

Sign up