Sometimes I’m timely in getting the news out on useful resources. And, other times, I’m a bit slower on the draw. As I told friends back at New Year’s Day, “As an official member of the Procrastinators Club, welcome to 2008!” On the other hand, it’s always good to remind folks of great resources that are still available and on the shelf. Why? Well, the Internet hits us with such a deluge of constantly new material, that we often forget about the old(ish) stuff that’s still really useful.
Darth Doofus, Emporer Palpatine, and Darth Goofus
Quest vConference for SQL Server
One of the most popular teaching sessions I ever engaged in was the Quest vConferences for SQL Server in 2010, with my good friends Buck Woody (blog | twitter) and Brent Ozar (blog | twitter).
These are evergreen favorites for their strong technical content and, perhaps, an outpouring of Brent’s faux chest hair in the latter part of the training events. Go to this URL for the code samples, download the slides, and to rate the presentation: http://questkb.com/live and or http://www.vconferenceonline.com/shows/spring10/quest/conference/ondemand.asp. You can also get the full events shipped for free anywhere in North America on a single DVD.
24 Hours of PASS Celebrates Women in Technology
Kalen Delaney, author and expert, and one of the initiators of WiT within PASS
It’s always a big thrill for me when a successful initiative launched by PASS goes viral. One such example is the 24Hours of PASS. (See last year’s webcasts at http://www.sqlpass.org/24hours/2010/). I now see other industry trade groups and technology user groups launching their own 24 Hours type webcast marathons. Kudos – PASS folks thought of it first! (I’d give proper credit, if I could only remember who thought of it. Rick Heiges (blog | twitter), I think).
This year, 24 Hours of PASS is gearing up for an exceptional lineup of SQL Server and BI experts in 24 one-hour technical webcasts. This free training event takes place over two 12-hour days March 15-16, with each day beginning at 12:00 GMT (UTC). Click here to get registered: http://www.sqlpass.org/24hours/Spring2011/. And in celebration of Women in Technology, PASS is hosting an all female line-up of speakers.
This is another area in which PASS has prompted many emulators. My memory of the details grow dim, since this was almost ten years ago, but I believe it was then PASS director Kalen Delaney (blog | twitter) and Microsoft liaison to the board Jacqueline Borges who put forward the idea of hosting a special Women in Technology luncheon. Since that time, WiT has gone on to be one of the best parts about the big PASS Summit and something widely emulated by other professional and trade associations.
Microsoft Thrive – Career Planning Insights
I was honored to be a featured speaker on the Microsoft Thrive website about this time last year. What’s Thrive? It’s a website put together by Microsoft that helps you plan out your career. It has certification and learning resources, career paths, and traditional learning patterns and practices. In other words, it tells you what you need to know to qualify for various kinds of it jobs and then gives you links to dive deeper. Check it out!
Cloud computing is more than just the latest buzz word in the IT trade papers. It is a remarkable paradigm shift with as much potential to “turn over the apple cart” of IT computing as client-server had for the world of mainframe and minicomputers. If you’re not spending time to learn about cloud computing, in general, and SQL Azure, in particular, then you’re missing the boat in a big way. (Ha! Two big metaphors in one afternoon. My high-school English teacher would be proud.)
There are mountains, literally MOUNTAINS, of free and high-quality content to be had. For example:
Fire Side Chats are invitation only Live Meetings. They are an hour in length, repeated at different times of day so you don’t need to attend at 3:00am because of time zone issues. Each Fire Side Chat has a key Microsoft individual talking about their area of expertise and answering questions from the audience. The Fireside Chats are aimed at technical experts, MVPs, user group leaders and the like. But they have content of interest for everyone. When looking at the archives, I noticed that there didn’t seem to be many recent chats. But some of the older ones still looked interested. You can register to see one at http://ug.gitca.org/sites/FireSideChats.
~~~
Microsoft Team Blogs of Interest
Do you ever wish that Microsoft consolidated all of their blogs in one easy to find central clearinghouse? Well, your wish was answered, actually quite a long time ago. BlogMS consolidates almost 250 Microsoft team blogs across a variety of Microsoft product and online services portfolio, with usually about 70 – 80 blog posts per week. Yes, children, that’s two to three HUNDRED blog posts per month.
You’ll find important announcements and details of Microsoft news, product releases, service packs and important support issues. On top of that, I really like all of the great links to Microsoft web resources on the right hand side of the website. If you’re like me (and let’s be honest, most rational or just sane people would not want anything of the sort), you’ll probably bookmark quite a few of those links.
The following BlogMS Resource Guides may also be of use:
You might be familiar with the term “Most Valuable Player”, but haven’t heard that MVPs exist in the professional world too. Microsoft has nearly 3,000 designated “Most Valuable Professionals”. These folks are designated experts who know their subject matter at an expert level and, as an added bonus, they don’t smell like a basketball locker room (SQLRockstar, Thomas LaRock, being a notable exception to this rule).
Late last year a cool new tool was launched called Microsoft Desktop Player. The player aggregates contextual technical content (webcasts, podcasts, white papers) from across all sorts of Microsoft websites having an IT Pro adoption lifecycle. In addition, it also provides links to local resources and news for the Developers and IT Pros based on their local settings, helping to drive the local engagement/relationship. You’ll need Microsoft Silverlight to run the website, but it’s oh-so-cool looking. Check out the details here: http://www.microsoft.com/click/desktopplayer.
One thing I really enjoy about the SQL Server community is its vibrancy. I’ll give you details on the SQL Server community’s explosive growth in a moment, but let’s start by comparing Microsoft SQL Server’s user community with those of other significant database platforms. [READ MORE]
On this vblog entry on www.sqlserverpedia.com I describe and discuss the Microsfot MCP (Master Certification Program). I hope this helps anyone that is interested in this program. Enjoy and I look forward to your feedback!
My session is entitled Leadership and Team Management Skills for the Database Professional. If you’ve ever attended my 1-hr professional development session at the PASS Summit, which has scored highest in the professional development track, then you’ve seen a preview of what we’ll be covering over the course of the full day.
During the session I will discuss how most IT leaders earned their promotions based on technical competency, not on leadership or managerial skills. Technical leaders rarely advance into leadership positions with the complex mix of social and soft skills that best facilitate their success and the success of their teams. Successful IT leaders require a combination of:
Earning the respect of your team
A deep understand of effectively motivating technology professionals
Specific skills to lead database professionals competently that broadly fall into the categories of:
Coaching team members to effectively meet goals and deadlines
Facilitating change and navigating organizational disruptions
Promoting communication within the team and with management
Keeping teams and projects on task and within scope
Dealing with difficult team members
Practicing good team time management techniques
I have three main goals for the session.
1.Developing skills which promote an understanding of your own personal motivations and what motivates the IT professionals on your team.
2. Developing skills which enable you and your team to meet goals set by management.
3. Developing the specific skills needed to lead a team of technologists.
I wanted to pass along this great info from Microsoft. There are literally oodles of free resources for Visual Studio programmers. In their own words…
Take Visual Studio for a Test Drive
Take this powerful tool and its features for a spin by downloading a full Visual Studio 2010 trial version. Discover how Visual Studio 2010 Professional helps individual developers build, test, debug software solutions. http://clk.atdmt.com/MRT/go/206383954/direct/01/
Attend an Event
Find out how you can ride the next wave of innovation ushered in by Microsoft Visual Studio 2010. Choose from full day, in-person Launch 2010 events in your area, or live half day Highlights events, featuring the most popular sessions from the Launch 2010 Technical Readiness Series. http://go.microsoft.com/?linkid=9725716
Visit the Visual Studio 2010 Developer Center
Find out how easy it is to get started with Visual Studio 2010. Get invaluable resources like “How do I” videos, MSDN Magazine, product and extension information, and much more. http://go.microsoft.com/?linkid=9725715
Watch a “How Do I” Visual Studio Video
Watch the “How Do I Videos” designed for Visual Studio 2010 developers, from novice to professional. This set of short videos will help guide you through common scenarios, features and functionalities. http://go.microsoft.com/?linkid=9727009
Attend a Visual Studio Webcast — Turn Ideas Into Solutions
Dive into these live and on-demand webcasts and learn how the features available in Visual Studio 2010 can make professional developers more productive while building high-quality applications. Dive in today! http://go.microsoft.com/?linkid=9727010
More Visual Studio Videos
Watch these free videos to explore Microsoft Visual Studio 2010 whenever and from wherever you want — just click, watch, and learn. Start by clicking the title to learn more about the video, you can then stream it or download to view offline. http://go.microsoft.com/?linkid=9727011
Download a Podcast
Listen to podcasts and learn about Visual Studio 2010 whenever and wherever you want. Download the latest audio content and hear about new features and enhancements that help developers build next generation applications. http://go.microsoft.com/?linkid=9727012
Visual Studio Virtual Labs
Virtual labs that you can download and learn how to program with Visual Studio. Using virtual labs is simple with no complex setup or installation required. http://go.microsoft.com/?linkid=9727013
Good grief, there’s a lot of travel in my immediate future. <sigh … deep breath> It’ll be exhausting and it’ll be hard to lose so much time with the family. But if I’m able to avoid travel mishaps, it’ll be fun.
The Gateway to the West
Meet Me In St. Louis
I’ll be speaking in St. Louis, MO on Tuesday, September 14th for their mid-day meeting. The details, as I have them, are:
Tuesday, September 14, 2010 1-4pm
Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO 63141 http://www.microsoft.com/about/companyinformation/usaoffices/northcentral/stlouis.mspx
Parking is in the garage behind / next to the building. There is an entrance to the building from the 2nd floor in the garage. Additional details and instructions on how to log in
Speaker: Kevin Kline, Quest Software
Topic: SQL Server Internals and Architecture
Speaker: Kevin Kline, Quest Software
Topic: SQL Statement Tuning with Query Optimizer Strategies
I’ll be giving away free t-shirts, posters, an eBook or three, and backrubs (super-models, only).
SQL Bits, On the Cheap
SQL Bits in the City of York Minster Cathedral
I’ve tweeted previously about the SQL Bits conference in York on September 30th – October 2nd, but this is my first blog post about it. Now is the time to settle your plans to attend. And while you’re settling those plans, take advantage of Quest Software’s 20% discount on the Thursday and Friday sessions requiring payment. Just be sure to use the code QST20 when you register.
The Saturday is free for everyone. Note – I said FREE. So if you’re struggling to convince your boss of the value of the time off and cost required to attend these events, then at least plan to attend Saturday. But as you can see here, the prices are quite low compared to most other conferences of similar quality.
I firmly believe the standard for speakers and content at SQLBits is second to none in the UK. I’ll be a wallflower in comparison to other friends of mine also speaking at the event, such as Brent Ozar, a MCM SQL Server and former colleague now working with SQLSkills, Buck Woody, the well-known “Real World DBA” and senior technical specialist from Microsoft, as well as many other SQL Server MVPs, authors, and speakers, such as the event organizer, Simon Sabin, and Quest Software SQL Server expert and editor-in-chief of SQLServerPedia, Iain Kick. Some sessions I’m looking forward to include:
Monitoring and Tuning Parallel Query Execution – Part II – R Meyyappan
Where the bl**dy h*** are you? (Spatial Data Visualisation) - Rob Farley (all the way from Adelaide, Australia)
Introduction to Performance Analysis and Tuning – Simon Sabin
Oracle for SQL Server DBAs – Gavin Payne
Lies, Damned Lies And Statistics. Making The Most Out of SQL Server Statistics – Maciej Pilecki
Extreme scaling with SQL Azure – Martin Schmidt
Automating SSIS – Andre Kamman
Attendance will definitely enhance your skills and ability to do your job. The added bonus is that York is a lovely place to visit with a beautiful and storied cathedral, so I highly recommend the event for all SQL Server professionals.
Prior to SQLBits, I’ll be presenting in London, Amsterdam, Copenhagen, and Stockholm. I hope you can attend an event closer to you if you cannot make it to York!
And Just to Make Sure I’m Thoroughly Frozen…
I prefer to think that the city will look like this with nary a flake of snow in sight
While I usually have a policy against visiting places cold enough to die between the front door and the mailbox, I’ll be stopping in at SQL Saturday 58 in Minnesota for a SQL Saturday taking place on Friday (not a typo), October 29th, the day after my birthday. I’ll be 21 years old and, since I’m now of legal drinking age, you should by me a drink. The event organizer, as well as my friend and fellow MVP, Jason Strate, just has to be different by holding the event on a Friday, eh? Track the event on twitter using the hash tag #sqlsat58.
We all know how hard troubleshooting SQL Server can be. There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor.
The only problem with SysMon, or more commonly “PerfMon”, is that it takes a lot of knowledge and experience to know which objects and counters to examine.
I’ve put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes.
You Can Has It Fer Free!
If you live outside of North America, get the hi-resolution PDF here.
If you live in North America, order the poster here, and it’s free including postage anywhere in the USA and Canada.
PerfMon is Irie, Mon!
But Wait There’s More!
And just in case you didn’t watch our virtual conferences back in March or in July, you can watch my “PerfMon is Irie, Mon” session that describes how to use Windows System Monitor and some related tools, all in my rasta-man costume.
Order a free copy of the events on CD here. Restrictions apply.
Each month, for six months, Arnie Rowland will be giving away a package of software, books, training, and development tools, valued at over $15,000, to an unemployed or underemployed developer that takes on a software project of his/her choice with a non-profit.
“The idea is to provide the recipient access to all of the tools needed to improve his/her skills, an opportunity to gain practical experience, the potential to earn a recommendation and/or referral –and to positively contribute to society as a form of ‘give-back’. No free lunch, just sweat equity –the kind that makes us all feel good for the effort.”
If you or someone you know is interested, the specifics are here.
Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA. Buck played Jerry Lewis’ role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here. Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had pretty good legs to stand on doing this presentation. Here’s the abstract:
In enterprise IT, database professionals face a mixed-bag of platforms within their environments — and the overlapping duties that go along with them. Whether you like it or not, you get asked to support Microsoft SQL Server operations even though you’re an Oracle DBA.
In this instructive webcast, experts from Microsoft and Quest with years of experience in both platforms will discuss the biggest issues and areas of interest for Oracle DBAs who need to work on Microsoft SQL Server. You’ll learn their tips and tricks for efficiency and gain a deeper understanding of SQL Server to help you add more value than ever to your organization.
Of course, there are always questions and we aim to please. Here are the transcripts of the Q&A chat session (below) that accompanies the presentation. The only editing I did was to remove blank questions. If you’re not familiar with Live Meeting, there’s always a [Q&A] menu on the top session bar where you can ask a question. Quick Tip – The Live Meeting Q&A queue is one question deep, meaning that if you write a question and then write another before the first question is answered, your original question drops out of the queue. Here’s the transcript:
Meeting Questions and Answers:
Subject: Pain of the Week Webcast - May 27, 2010
Start Time: Thursday, May 27, 2010 10:00:00 AM GMT-5:0
Gabe Kovacs Asked: Do I need to call the hear the audio for this presentation?
Christian Answered: Yes, you will need to call the toll free number – 1888-253-4037 PC: 319874
Luis Cardenas Asked: Morning could you kindly tell me which is the passcode for teleconf?
Christian Answered: 319874
Jossy Tonio Asked: Is it started?
John Allman Asked: What is the PASS CODE for the audio?
inho Asked: To provide similar service level for Oracle database recovery using EMC SRDF and VCS/GCO, for
inho Changes Question To: To provide similar service level for Oracle database recovery using EMC SRDF and VCS/GCO, what similar DR solution(automatic failover, synchronous data replications) is available with SQL Server ?
Roy McBroom Asked: Who’s Pat Boone?
Luis Cardenas Asked: Is there any chance we could get the slides? They seem useful.
John Allman Asked: What is the PASS CODE for the audio?
Luis Cardenas Asked: Is there any chance we could get the slides? They seem useful.
hre Answered Privately: yes. they will be sent out to all attendees after the live event.
Jerry Mu Asked: I know sql server only has one tempdb that is public to all session. Oracle can create all temp tablespace. is there bottleneck in sql server if application is bigger and busy?
Jerry Mu Changes Question To: I know sql server only has one tempdb that is public to all session. Oracle can create all temp tablespace. is there bottleneck in sql server if application is bigger and busy?
inho Asked: To provide similar service level for Oracle database recovery using EMC SRDF and VCS/GCO, what similar DR solution(automatic failover, synchronous data replications) is available with SQL Server ?
Kevin Kline (Qsft) Answered: clustering, mirroring, replication and identical EMC features
Roy McBroom Asked: Who’s Pat Boone?
Kevin Kline (Qsft) Answered: A 50′s and 60′s era singer renown for his appeal to white middle-class americans
Jerry Mu Asked: I know sql server only has one tempdb that is public to all session. Oracle can create all temp tablespace. is there bottleneck in sql server if application is bigger and busy?
Kevin Kline (Qsft) Answered: tempdb can be tuned to allow multiple filegroups and, thus, multiple IO paths
DBA_Joseph Asked: What portions of the Oracle SYSTEM tablespace live in the MS-SQL “master” database, and what pieces of that info live elsewhere in MS-SQL?
Ray Herrera Asked: Can you customize the model database?
Wayne Starnes Asked: dive a little deeper into ORACLE ‘user’ being a schema object, vs SQL database and the users as the schema
Ray Herrera Changes Question To: Can you customize the model database?
Jerry Mu Asked: You mean muilple file? like how many CPU and we can create files to match CPU. But I think that will create file fragmentation, is that right? Any plan for sql server to support muilple tempdb, like sybase did?
DBA_Joseph Asked: What portions of the Oracle SYSTEM tablespace live in the MS-SQL “master” database, and what pieces of that info live elsewhere in MS-SQL?
Kevin Kline (Qsft) Answered: It’s about equal. SYSTEM + SYS on Oracle = MASTER on MSSQL
Ray Herrera Asked: Can you customize the model database?
Kevin Kline (Qsft) Answered: absolutely!
Moorthy Rekapalli Asked: Can you please expand on the concept of user and schema in SQL Server and please relate that to Oracle as I am more familiar with that.
Wayne Starnes Asked: dive a little deeper into ORACLE ‘user’ being a schema object, vs SQL database and the users as the schema
Kevin Kline (Qsft) Answered: sorry Wayne, not enough time. links for that at the end.
Robert Stewart Asked: does the master database corralate to the sys user in Oracle
Moorthy Rekapalli Asked: Can you please expand on the concept of user and schema in SQL Server and please relate that to Oracle as I am more familiar with that.
Kevin Kline (Qsft) Answered: Sorry Moorthy, not enough time. But there are links for that at the end.
Robert Stewart Asked: does the master database corralate to the sys user in Oracle
Kevin Kline (Qsft) Answered: SYSTEM + SYS on Oracle = Master on MSSQL
Jerry Mu Asked: You mean muilple file? like how many CPU and we can create files to match CPU. But I think that will create file fragmentation, is that right? Any plan for sql server to support muilple tempdb, like sybase did?
Kevin Kline (Qsft) Answered: Yes, you can correlate CPUs to files. It does not contribute to unusual file fragementation.
rick stehno Asked: you don’t want to use OPS$ because it is not as secure as the other methods and you indicated that sql server access is similar to OPS$. this isn’t a good thing is it?
Luis Cardenas Asked: what about synonyms, in oracle we use to managa certains aspect of sucurity do they exist in SQLServer?
rick stehno Asked: you don’t want to use OPS$ because it is not as secure as the other methods and you indicated that sql server access is similar to OPS$. this isn’t a good thing is it?
Kevin Kline (Qsft) Answered: Ops$ is similar but not as comprehensive as Windows authentication
Luis Cardenas Asked: what about synonyms, in oracle we use to managa certains aspect of sucurity do they exist in SQLServer?
Kevin Kline (Qsft) Answered: Coming in the next release
DBA_Joseph Asked: Just to clarify:: For efficiency ++ To reduce I/O, I take it, that DB-changes are cached in MEMORY, (like Oracle’s SGA) as well as the transactin log… and the MS-SQL then migrates those changes to Database storage… To clarify earlier statement about user writing to LOG and then another process reads log and writes to database…
Ray Herrera Asked: Does MSSQL have something similar to the Oracle’s archive log mode operation?
Jim Rice Asked: does the full method emulate the oracle archive log process
Ray Herrera Asked: Does MSSQL have something similar to the Oracle’s archive log mode operation?
Kevin Kline (Qsft) Answered: I think we’re touching on that now
Jim Rice Asked: does the full method emulate the oracle archive log process
Kevin Kline (Qsft) Answered: similar indeed
DBA_Joseph Asked: Just to clarify:: For efficiency ++ To reduce I/O, I take it, that DB-changes are cached in MEMORY, (like Oracle’s SGA) as well as the transactin log… and the MS-SQL then migrates those changes to Database storage… To clarify earlier statement about user writing to LOG and then another process reads log and writes to database…
Kevin Kline (Qsft) Answered: yes, they’re cached in ram until checkpoint
PB Asked: Can SQL Server do block/page level recovery if a corrupt block/page is found on a datafile?
bhupendra Asked: How is the transaction log size determined
Chakrapani Asked: Is there any tool like RMAN in SQLSERVER for backing deltas?
PB Asked: Can SQL Server do block/page level recovery if a corrupt block/page is found on a datafile?
Kevin Kline (Qsft) Answered: It’s possible, but not easy. see the dbcc page command on-line
bhupendra Asked: How is the transaction log size determined
Kevin Kline (Qsft) Answered: there are defaults, but it’s easy to change
Chakrapani Asked: Is there any tool like RMAN in SQLSERVER for backing deltas?
Kevin Kline (Qsft) Answered: The native backup supports deltas, called differentials. It’s much easier IMO than Oracle’s RMAN
Michael Asked: about user you mentioned, is it the same as Login account? How do you link login account or user to database, schema,..?
DBA_Joseph Asked: DB=Consistant as of finish… this means that backup also pulls info from LOG file, as part of backup set?? Is there an MS-SQL equivalent to Oracle “Recover Database” or is this just so transparent & automatic that it transparent?
Suresh Asked: Good point Kevin …i know Oracle DBA ‘s are very fond of RMAN
Kevin Kline (Qsft) Answered: thanks! =^)
DBA_Joseph Asked: DB=Consistant as of finish… this means that backup also pulls info from LOG file, as part of backup set?? Is there an MS-SQL equivalent to Oracle “Recover Database” or is this just so transparent & automatic that it transparent?
Kevin Kline (Qsft) Answered: the recovery process will roll forward any transactions directly from the transaction log as needed
Michael Asked: about user you mentioned, is it the same as Login account? How do you link login account or user to database, schema,..?
Kevin Kline (Qsft) Answered: sorry, too many questions to keep up with your reference to “user”. could you restate?
Kenny Smith Asked: Do you know of a website or resource that will compare/contrast task details in Oracle to the similar task in SQL Server?
djb Asked: Isn’t it true that SQLServer benfitted from all the lessons that Oracle learned as it was developed earlier. For example, Oracle didn’t have a hot backup faicilirt at first. SQLServer was developed with that from the start.
Vladimir Lugo Asked: Can you explain a bit about clustering differences?
Carmen Asked: Our backup of master fails because of a single-user mode error. Is there something special that should be done to include master in the backup plan?
Haridas Asked: Is it possible to add Disk space without much re-org ? (In oracle SAN disk space re-org is quite a challenge)
Kenny Smith Asked: Do you know of a website or resource that will compare/contrast task details in Oracle to the similar task in SQL Server?
Kevin Kline (Qsft) Answered: nope. no one goes that deep
Michael Asked: In the security slide, User is mentioned, is it the Loing Account?
Kenny Smith Asked: How can you audit active directory user “BuckWoody” and his actions through a database role via a Active directory Group on database objects?
Suresh Asked: what about BI tools in comparison to Oracle’s? SQL BI in 2005 seems very famous now?
Vladimir Lugo Changes Question To: Can you explain a bit about clustering differences?
Haridas Asked: Is it possible to add Disk space without much re-org ? (In oracle SAN disk space re-org is quite a challenge)
Kevin Kline (Qsft) Answered: absolutely – alter database supports this
Robert Stewart Asked: does the index rebuild do so online?
Mauricio Lopez Asked: Hi, will you put the presentation file as a Handout file or where can we download it ? Thanks
Michael Asked: In the security slide, User is mentioned, is it the Loing Account?
Kevin Kline (Qsft) Answered: Login and User are actually distinct, though usually linked
DBA_Joseph Asked: For all USERS of this Q+A screen… It is not allowing users to Select+Copy the text. Is there a way to save this list of DBA questions, so we can paste into a file, to remember/review other peopel’s questions later?
Mauricio Lopez Asked: Hi, will you put the presentation file as a Handout file or where can we download it ? Thanks
Kevin Kline (Qsft) Answered: Of course – you’ll get a follow up email!
Bob Asked: will running select statement lock a table on the page level? or only DML will lock the table?
Bob Changes Question To: will running select statement lock a table on the page level? or only DML will lock the table?
djb Changes Question To: Isn’t it true that SQLServer benfitted from all the lessons that Oracle learned as it was developed earlier. For example, Oracle didn’t have a hot backup facility at first. SQLServer was developed with that from the start.
Bob Changes Question To: will running select statement lock a table on the page level? or only DML will lock the table?
sharath Asked: Is it possible to have data replication like in oracle for example materialisezd views or streams or data guard?
Luis Cardenas Asked: Excellent webcast thanks!!
Kenny Smith Asked: How can you audit active directory user “BuckWoody” and his actions through a database role via a Active directory Group on database objects?
Kevin Kline (Qsft) Answered: Check out a feature called CDC “change data capture”
sharath Asked: Is it possible to have data replication like in oracle for example materialisezd views or streams or data guard?
Kevin Kline (Qsft) Answered: All of those are features in SQL Server = indexed views, replication, and clustering/mirroring
DBA_Joseph Asked: For all USERS of this Q+A screen… It is not allowing users to Select+Copy the text. Is there a way to save this list of DBA questions, so we can paste into a file, to remember/review other peopel’s questions later?
Kevin Kline (Qsft) Answered: I’ll get them sent to you
Robert Stewart Asked: does the index rebuild do so online?
Kevin Kline (Qsft) Answered: In Enterprise Edition, but not in lower editions
