archive-be.com » BE » S » SQLUG.BE

Total: 294

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Announcements - SQLUG.be
    The Grand A quick break down of what you might expect Day 1 7th April Pre Conference Training Day Choose from one of eight Full day seminars by SQL Server experts on a wide range of aspects of SQL Server Day 2 8th April 20 25 sessio SQL Server Day Slides With 225 attendees the averse weather conditions and the mega traffic jams SQL Server Day has been a huge success once again Thank you for attending Had difficulties to choose the right session in one of our tracks Missed a session No worries the slidedecks are available on our website Fill in a short survey and the slide decks will be sent to you You will also be entered into a free p Can t Make it to PASS Summit 2010 Join in for the Live Streaming Keynotes Participants from across the globe can join in the PASS Summit experience at no cost by tuning in for this series of can t miss Keynotes Register today Top Microsoft SQL Server executives Ted Kummert Quentin Clark and David DeWitt will take center stage at PASS Summit 2010 to share the latest SQL Serv Twitter Trackbacks for SQLUG be sqlug be on Topsy com Pingback from Twitter Trackbacks for SQLUG be sqlug be on Topsy com Belgian SQL Server Day 2010 on December 2nd For the third successive year the Belgian SQL Server User Group SQLUG BE vzw and Microsoft are teaming up to organize the yearly Belgian SQL Server Day After the successful event of last year SQL Server Day 2010 will again be the biggest event focused exclusively on SQL Server in Belgium and Luxembourg Join us for sessions on SQL Azure SQL Server 2008 R2 the Microsoft Busin Dutch SQL Zaterdag on October 23rd Our SQL friends in the Netherlands are organizing their 2nd SQL Saturday Het is geinspireerd door populaire evenementen als de diverse Code Camps in de net wereld SQLSaturday SQL Server Day en het zeer populaire SQLBits Het bleek een succes we hebben de inschrijving enkele dagen voor het evenement moeten stoppen want we hadden de maximale capaciteit van de zalen Post your question for our Ask the Experts and win a free ticket for SQL Bits in the UK Another day and another great give away Send us your SQL MS BI quetions for our Ask the Experts event on September 29th to asktheexperts sqlug be and get a change to win a free entrance ticket for the SQL BITS conference in the UK This free ticket entitles one person who has not already registered to register for all three days the training day the Friday conferen Give away 2 free tickets for DevCon in London We are pleased to announce that we are able to provide 2 free tickets for attending DevCon London DevCon London will take place in London from September 27 29 2010 More information on the conference the topics covered and the location can be found at www devconlondon com DevCon London is a brand new conference which will provide an exciting forum for software developers project managers an Twitter Trackbacks for SQLUG be sqlug be on Topsy com Pingback from Twitter Trackbacks for SQLUG be sqlug be on Topsy com TechNet Livemeetings Managed Self Service Business Intelligence with PowerPivot 30 09 Managed Self Service Business Intelligence with PowerPivot English PowerPivot is Microsoft s offering in the Managed Self Service Business Intelligence space It is one of the most facinating BI software releases in the last couple of years and it will dramatically change the way business people and IT departments develop and implement BI solutions In this demo driven session Freder Free TechNet Event Are you ready for a journey to the cloud Have you heard about IaaS SaaS PaaS Private and Public cloud Do you know what it means and how this technology can help your customers your company and your business As with any journey many different challenges are ahead Join us with a journey to the cloud where you will learn more about Microsoft Public and Private cloud offerings During this journey we will cover following topics Next UG event Ask The Experts 29th of September Mark your calendar for the 29th of September for the Ask The Experts event SQLUG teams up again with Microsoft to organize this panel of hardcore SQL Server experts with Wesley Backelant MSFT Frederik Vandeputte MVP Dirk Gubbels MSFT and Gunther Beersaerts MSFT Starts 19 00Location Microsoft BelgiëSend your SQL Server related questions to asktheexperts sqlug be We will answer as man Get a 200 discount for SQL Pass Summit in Seattle This years SQL PASS Summit 2010 will take place on November 8 11 2010 in Seattle The SQL PASS Summit is the largest SQL Conference in the world with Over 160 technical sessions from the world s top SQL Server and BI experts 2 full days of deep dive Pre and Post Conference Seminars Networking with thousands of SQL Server MVPs experts Microsoft employees and peers Face to Get a 20 discount for the SQLBits Conference in England Our friends in the UK are organising SQLBits The 7 Wonders of SQL conference which will be taking place from September 30th to October 2nd at York University SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established it as a must attend event for DBAs developers and BI professionals who work with Microsoft SQL Server in the UK and Europe This t SQL Server Jobs at Kohera Our Gold Partner Kohea is looking for a SQL Server DBA and a MS Business Intelligence Constultant Please have a look at our job section for more details Slide Deck SQLUG Event System Center Operations Manager 2007 R2 The slides from System Center Operations Manager 2007 R2 event on the 20th of May are available for download Practical SQL Server 2008 for the Oracle DBA Online Seminar This 2 day Online Seminar is to help Oracle database administrators DBAs leverage their skills and experience as an Oracle DBA to manage a SQL Server system This seminar will provide a quick start for the Oracle DBA to map compare and contrast the realm of Oracle database management to SQL Server database management June 21 22 9 5pm Australia East https msevents mi Twitter Trackbacks for SQLUG be sqlug be on Topsy com Pingback from Twitter Trackbacks for SQLUG be sqlug be on Topsy com Next SQLUG event on What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers May 20th Managing SQL Server requires insight in the state and performance of the underlying infrastructure OS and individual SQL components System Center Operations Manager 2007 R2 cannot only give you that insight but it can be reused in a broader application service monitoring view This session focuses on the out of the box capabilities of System Center Operations Manager 2007 R2 but also shows you ho SQL Server 2008 R2 RTM Today Microsoft released the RTM version of SQL Server 2008 R2 The trial version is available on the following URL http www microsoft com downloads details aspx displaylang en FamilyID 54ad6107 c552 4d47 b1a1 3f66460f71a9 More related downloads can be found via Download Center http www microsoft com downloads en results aspx freetext sql server 2008 R2 displaylang en amp Get a 10 discount on SQL Server training at Global Knowledge Global Knowledge offers SQLUG be members a 10 discount on selected SQL Server courses Code Description Date List Price SQL UG Price M2778 Writing Queries using SQL Server 2008 26 05 1 200 1 080 M6231 Maintaining a SQL Server 2008 database 28 06 1 750 1 575 M6232 Implementing a SQL Server 2008 database 07 06 1 75 Slide deck SQLUG event Resource Governor The slides from the Resource Governor event on the 8th of april are available for download Community Day 2010 Community Day is back with the Fourth Edition of this annual community event on Microsoft technologies Fourteen Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharingevent With so many new releases from Microsoft the theme of Community Day 2010 is of course 2010 a new wave of products and technologies This means that most sessions will be looking Wanted your input on Web Administration of SQL Server and SQL Azure The SQL Server product team is thinking about Web Administration of SQL Server and SQL Azure and is looking for customer input feedback Please take a short survey http www surveymonkey com s 978R8TB on this subject Free tickets for Star Wars in Concert We have 10 free tickets for Star Wars in Concert for tomorrow night Sportpaleis Antwerp Visit us tomorrow at our booth on the Techdays and mention the magic word SQL Server 2008 R2 D2 Twitter Trackbacks for SQLUG be sqlug be on Topsy com Pingback from Twitter Trackbacks for SQLUG be sqlug be on Topsy com Chalk Talk sessions on the Belgian Techdays We are happy to announce that a number of IT Pro community groups are joining forces this year to bring you two highly interactive Chalk Talk sessions on the Belgian Techdays The concept is very simple If you have that one question you have been dying to ask a leading technology expert this is your chance Bring your question and join a panel of MVP s and tech experts during t Next SQLUG evening event on Resource Governor April 8th Resource Governor is a new technology in SQL Server 2008 that enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming request In this session you will learn how to define a classifier function to sort your request in resource groups that will be assigned to resource pools dividing up your CPU and memory resources Monitoring of resource A Developer 039 s Blog middot Save up to 35 for the PASS European Conference Pingback from A Developer s Blog Save up to 35 for the PASS European Conference SQL Server Service Broker and some of the things it can do for you The presentaion and demo fiels are available Click here to download SQL Server 2005 SP3 and SQL Server 2008 SP2 MSFT announced on the Global Releases Services Team blog they will release new service packs for both SQL Server 2005 and SQL Server 2008 in Q4 and Q3 respectively Read more on http blogs msdn com sqlreleaseservices default aspx A Developer 039 s Blog middot PASS European Conference 2010 Pingback from A Developer s Blog PASS European Conference 2010 Save up to 35 for the PASS European Conference use promo code BEC15Y We are very proud to offer our members a special discount code that offers significant savings for any PASS European Conference 2010 registration It s an even better discount than Early Bird registration Use discount code BEC15Y and enjoy the following savings for PASS European Conference Conference Prices 19 VAT additional SQL Zaterdag We inspired our Dutch friends at PASS Nederland with SQL Server Day On March 6th they are organising their first full day event Full details can be found on http www sqlzaterdag nl Good luck guys SQL Zaterdag is geen nieuw soort event maar wel nieuw voor Nederland Het is geinspireerd door populaire evenementen als de diverse Code Camps in de net werel February 11th next UG evening on Service Broker SQL Server Service Broker and some of the things it can do for you is brought to you by Nico Jacobs and will take place on February 11th Since SQL server 2005 it is possible to build a Service Oriented Architecture SOA inside SQL Server The component that enables this is the service broker a message based system which allows for dialogs between two SQL server instances In this sess Upcoming Technet Livemeetings on managing the SQL Server 2008 data platform Vereenvoudig het management van uw SQL Server 2008 Data Platform In deze sessie bekijken we de management kant van Microsoft SQL Server 2008 en gaan we dieper in op de uitdagingen waarvoor database beheerders staan Topics die we zullen behandelen zijn onder meer het managen van complexe en high value taken proactieve monitoring en tuning van de gezondheid van uw A Developer 039 s Blog middot Free SQLUG Evening Service Broker Pingback from A Developer s Blog Free SQLUG Evening Service Broker TechDays Pre Conf BI with SQL Server 2008 R2 and Office System 2010 with Rafal Lukawiecki A must see for any who s working with or thinking about Microsoft BI Rafal Lukawiecki is probably the most gifted speaker on this topic Full Details on http www techdays be BI with Microsoft SQL Server 2008 R2 and Microsoft Office System 2010 We will examine an end to end approach to building and delivering a BI solution using the Microsoft BI platform We will focus Twitted by sqlug Pingback from Twitted by sqlug The Belgian SQL Server user group wishes you happy holidays Enjoy the holidays We ll see you back next year Social comments and analytics for this post This post was mentioned on Twitter by sqlug SQL Server Day 2009 videos now available on Chopsticks Microsoft has made all sessions presented on SQL Server Day http bit ly 8H2civ SQL Server Day 2009 videos now available on Chopsticks Microsoft has made all sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb High availability for BI DWH by SQL Server Day 2009 website live and registration open On Thursday the 3rd of December 2009 SQLUG BE The Belgian SQL Server User Group and Microsoft are teaming up to organize the second Belgian SQL Server Day Focus of the day is off course SQL Server Last year SQL Server Day 2008 was the biggest community driven SQL Server event in the Benelux with more than 200 attendees The event will kick off with an international speaker Technet Event Virtualization from Desktop to Datacenter 17 November 2009 On November 17th Microsoft is hosting a Technet Event on Virtualization from Desktop to Datacenter Using products that span the desktop to the data center you can bring capacities online in real time as needed streamline and provision applications services and data on demand accelerate backup and recovery and enhance availability so that your users are well protected against system failure Make Money Online Affiliate marketing The big make money way ProBlogr Pingback from Make Money Online Affiliate marketing The big make money way ProBlogr Twitter Trackbacks for SQLUG be sqlug be on Topsy com Pingback from Twitter Trackbacks for SQLUG be sqlug be on Topsy com Technet Roadshow The New Efficiency On October 27th and 29th Microsoft is hosting two Technet roadshows on Windows 7 Windows Server 2008 R2 and Exchange Server 2010 Sign up for a live launch event near you to experience hands on labs live demos and hear MVPs and industry leaders demonstrate how these products can work for you This is this year s best chance to learn and network with your peers and explore the new eff UPDATE Zero Downtime upgrade from SQL Server 2005 by Dirk Gubbels Presentation files and video available We have posted the files used during the presentation to the site They are available from the following link The session was recorded and can now be watched on Chopsticks Part I http www microsoft com belux technet nl chopsticks default aspx id 1429 Part II http www microsoft com belux technet nl chopsticks default aspx id 1431 Once again thank you Dirk for a very interesting Next UG event Zero Downtime upgrade from SQL Server 2005 by Dirk Gubbels Sep 24th 2009 On September 24th we kick off a new year of SQLUG events To be sure we kick off properly we hired a top speaker namely Dirk Gubbels Dirk is one of our best guest speakers and by far one of the best SQL Server professionals Dirk Gubbels is a senior consultant at Microsoft and has been working with SQL Server since version 4 2 As one of the few Microsoft Certi Twitted by sqlug Pingback from Twitted by sqlug Upcoming Technet events In the comming weeks and months Microsoft is hosting some very interesting Technet events including a live meeting on SQL Server Integration Services Full details can be found on the links below Live Meeting Secure Web Access with TMG 8 september 2009 Live Meeting Transitioning from Exchange 2003 Exchange 2007 to Exchange 2010 17 september 2009 SQL Server 2008 R2 August CTP Available Today Today Microsoft released the first community technology preview CTP of Microsoft SQL Server 2008 R2 for MSDN and TechNet subscribers A public CTP will be available on Wednesday August 12th Building on the momentum of SQL Server 2008 R2 improves IT efficiency by reducing the time and cost of developing and managing applications empowers end users to make better decisio Recordings of last event available on Chopsticks Two new SQLUG BE session are now available on Chopsticks Overview of Visual StudioTeam System 2008 Database Edition by Bart Wullems The Azure Services Platform and SQL Services by Kurt Claeus Enjoy the movies Presentations of june 4th Available for download We zipped presentations and samples of both events and can be downloaded from the following URL http sqlug be media p 1092 aspx Enjoy Buy phentermine online Phentermine Generic phentermine Mg buy phentermine Phentermine free shipping Phentermine risk Online phentermine Next UG event Visual Studio Team System 2008 Database Edition The Azure Services Platform and SQL Services Jun 4th 2009 This evening will be split into 2 sessions as follows Session 1 Overview of Visual StudioTeam System 2008 Database Edition Bart Wullems Solution Architect ALM specialist and Microsoft Certified Trainer at ORDINA Microsoft s Visual Studio for database professionals was originally designed to fill a gap in database development by providing features for manag SQL Server sessions on Community Day Eleven Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing event A unique opportunity to learn about Microsoft s latest developments and technologies like Exchange 2010 Silverlight 3 Visual Studio 2010 SQL Server 2008 Windows 2008R2 Powershell V2 Forefront Identity Manager 2010 XNA 3 1 and OCS R2 SQLUG BE is presenting two sess Cumulative update package 2 for SQL Server 2008 Service Pack 1 is available Cumulative update package 2 for SQL Server 2008 Service Pack 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008 Service Pack 1 Note This build of the cumulative update package is also known as build 10 00 2714 We recommend that you test hotfixes before you deploy them in a production environment Because the builds are cumul Microsoft announces SQL Server 2008 R2 Today Microsoft announced the next version of SQL Server SQL Server 2008 R2 aka Kilimanjaro The first details can be found on http www microsoft com sqlserver 2008 en us r2 aspx Make sure to register yourself on the site and and you will be notified when the CTP bits become available Upcoming User Group events BESUG SQLUG VISUG An update is due with all upcoming events organized by the very active user groups But first save the Next Evening Event Business Intelligence in a SAAS software as a service Environment April 29th 2009 This event is brought to you by InfoSupport and handles the implementation of BI within a SAAS concept Agenda Oscar Zonneveldand and Josquin Booij from InfoSupport will discuss the following topics 1 The Business Case 2 The Functional and Technical Architecture 3 Near realtime BI 4 The Real world About the speakers Oscar Zonneveld SQL Server 2008 SP 1 Released Today Microsoft released SQL Server 2008 SP1 Key improvements in SP1 include Slipstream Service Pack Uninstall and Report Builder 2 0 click once deployment Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance This decreases the total time for an installation including a fewer number of reboots thereby increasing productivity and deployme TechNet Event Solutions for Business Intelligence and Performance Management How to Go From Data to Decisions In this one day seminar Rafal Lukawiecki aims to show IT Managers and BI practitioners how to improve decision making and getting the valuable business insight by using Microsoft solutions This seminar will look at an end to end approach to building and delivering a Microsoft BI solution from automated data integration and consolidation to delivering insight in reports scorecards and Excel Member Benefit Norwergian Developers Conference One of the world s best developer conferences takes place in exotic Oslo in June this year Featuring 25 of the world s most wanted experts within software design and development for 2 full days and 7 different tracks it will be a truly amazing show But wait that s not all There is a third day with all the agile you can eat served up by agile superstars like Mary Poppe SQL Server and SharePoint webcast on Wednesday BH Server Pingback from SQL Server and SharePoint webcast on Wednesday BH Server SQL Server and SharePoint webcast on Wednesday Brent Ozar SQL Server DBA at Quest Software will be hosting a webcast on Wednesday at 1600 CET 11am Eastern 8am Pacific 1500 GMT I m doing a SQL Server SharePoint webcast with Doug Davis of Quest about why DBAs need to pay attention to SharePoint and what they need to learn first They will give a brief runthrough of Quest s products for Sharepoint too Visit http MDX From Zero To Hero Presentation and samples available for download Below you will find a link to the Presentation and samples from our UG evening hosted by Microsoft Presentation and samples Enjoy Augmented Reality is here As you all know last week we had the Tech Days in Antwerp where we saw a live demo of a really cool awareness campaign around Microsoft s SQL Server Wat is it all about Well when you hold this SQL Pattern in front of your webcam you will see a 3D rendered animation appear in front of you I have to say that it is really cool Try it for yourself No additional software is needed just al Next UG evening MDX From Zero To Hero registration open Next UG evening on Thu March 19t MDX From Zero To Hero MDX from zero to hero This session is brought to you by Franky Leeuwerck from Kohera MDX is the language that allows you to query a SQL Server Analyses Services multi dimensional data structure or OLAP cube In this session after a brief review on the concepts of an OLAP cube the MDX syntax for querying a cube w SQL Server 2008 Service Pack 1 CTP SQL Server 2008 Service Pack 1 CTP http www microsoft com downloads details aspx FamilyID 6f26fc45 f0ca 49cf a6ee 840c7e8bb8af displaylang enSQL Server 2008 Express Edition Service Pack 1 CTP http www microsoft com downloads details aspx familyid 0F8DF01E B05B 401B 87E7 BC516683CFE0 displaylang en Updated Member benefit European Pass Conference Between April 22nd and April 24 SQLPass organises the European PASS Conference in Germany With 36 technical sessions and much more this is the largest SQL Server related event in Europe As an offical SQL Pass Chapter SQLUG BE can offer our members a nice discount on the Conference Price If you want to take advantage please use BE138M as a promotion code during registration The Holy Trinity available on Chopstick The video of our last UG evening by Marc Mertens of Global Knowledge is posted on Chopsticks http www microsoft com belux MSDN nl chopsticks default aspx id 957 http www microsoft com belux MSDN nl chopsticks default aspx id 958Sit back and enjoy 4 hours of Indexes Execution Plans and the optimizer SQL Server Challenge ZDNet be On ZDNet be you can demonstrate your SQL Server Knowledge and make a change to win some nice prices Full details and contest can be found on http www zdnet be challenge cfm Central portal for all Belgian Microsoft Related User Groups mscommunity be MSCommunity be is the landing page for the Belgian Microsoft Community The purpose of this site to give you an overview of all the events being organized by Belgian Microsoft Usergroups so you ll never miss out on an event anymore The website was created by Gill Cleeren Targit Benelux new Gold Partner SQLUG BE We are very proud to announce our gold Partnership with Targit Benelux Targit Benelux is the exclusive distributor of Targit BI dashboarding analysis software and TimeXtender ETL in the Benelux TimeXtender is the leading solution for creating MS SQL server Data Warehouse solutions SSAS OLAP cubes and SSIS ETL packages Targit Business Intelligence offers the most complet Leo Werrens wins a free ticket for Techdays Last Thursday Leo Werrens won the free ticket for the upcoming Techdays Congratulations Leo During TechDays in March get all the tools you need to shape your knowledge Whether you re working for an enterprise corporation or a small business in the private or the public sector you can broaden and deepen your technical skills in Antwerp on 11 12 March 2009 The Holy Trinity Indexing the optimizer and execution plans Presentation and samples available for download Below you will find 2 links to both the presentation and the samples examples Presentation Samples Examples Win a free ticket for the Belgian Techdays in March On March 10th 11th and 12th the Belgian Techdays will take place in Antwerp Full details can be found on www techdays be On Thursday we will give away a free entrance ticket for the 3 days conference If you haven t registered for The Holy Trinity Indexes Execution Plans and the optimizer make sure to do so here Looking forward to see on Thursday Next UG evening The Holy Trinity Indexes Execution Plans and the optimizer This UG evening will start with an introduction of the basics of index design the heap clustered non clustered indexes and covering of a query by an index Later we will discuss how the optimizer works why it can be wrong statistics procedure cache and how to correct this Another part of the session will be some advanced features of indexing like partitioning locking and filt SQL2005 SP3 released What s New in SQL Server 2005 SP3 Microsoft SQL Server 2005 Service Pack 3 SP3 contains all the cumulative updates for SQL Server 2005 and fixes to issues that have been reported through our customer feedback platforms These include supportability enhancements and issues that have been reported through Windows Error Reporting SQL Server Day Presentations are available for download Below you will find an overview of all the presentations given during the SQL Server Day with their respective links for download SQL Server 2008 What s in it for you by Ian MacDonald download New T SQL programmability features in SQL server 2008 by Dirk Gubbels download Scaling Up Your Data Warehouse with SQL Server 2008 by Geert Vanhove download Secrets of BI Succes by Koen The day after SQL Server Day Dear SQL Server Day attendee First of all we want to thank you for attending SQL Server Day 2008 We hope that you enjoyed the day as we did We believe you would agree with us that it was a great success Evaluation Form We value your opinion so we would like to ask you to fill in our online evaluation form so you can help us to improve the SQL Server Day and all our future eve The OLAP Report Project Gemini Microsoft s Brilliant OLAP Trojan Horse Project Gemini was announced at the second annual Microsoft BI Conference in Seattle on October 6 2008 and there is no doubt that it was the highlight of the three day conference The Gemini code name is meant to imply that Excel and Analysis Services and end users and IT will be twinned using the new product but our pun BOTH reflects the view that Gemini appears to be both a brilliant wa SQLServerDay be is live On Thursday the 4th of December 2008 SQLUG BE and Microsoft are teaming up to organize the first Belgian SQL Server Day Focus of the day is off course SQL Server 2008 The event will be the biggest community driven SQL Server event in Belgium with an estimate of 200 attendees eager to learn get answers to their questions and also important socialize Keep an eye on the www sq UPDATED UG evening about SQL Server 2008 Integration Services downloads available Last Thursday 60 people joined us on our UG evening on Integration Services Thanks again to Kohera for sponsoring this event and a big thank you to Nico and Geert for the great sessions Powerpoint and sample packages of both sessions can be downloaded on the links below Improving SSIS performance Geert Vanhove What s new in SSIS 2008 Nico Verheire Free registration is requir Belgian SQL Server Day Call for speakers On Thursday the 4th of December 2008 SQLUG BE The Belgian SQL Server User Group and Microsoft are teaming up to organize the first Belgian SQL Server Day Focus of the day is off course SQL Server 2008 The event will be the biggest community driven SQL Server event in Belgium with an estimate of 200 attendees eager to learn get answers to their questions and also important Next UG evening on Thu September 25 about SQL Server 2008 Integration Services On September 25th we organize our next SQLUG BE event We have 2 session on Integration Services Registration is needed and is open Session 1 what s new in SSIS 2008 by Nico Verheire Abstract Integrating data with ADO NET Scripting with VSTA Introducing the new lookup transformation including caching Managing change in a data warehouse how to use Change Data Capture CDC an SQLUG BE is now an official SQLPass Chapter We are very proud to announce that we are now an official SQL Pass Chapter The Professional Association for SQL Server PASS is an independent not for profit association dedicated to supporting educating and promoting the Microsoft SQL Server and Microsoft Business Intelligence BI community User run PASS facilitates networking information exchange and continual learning thr Microsoft Releases SQL Server 2008 REDMOND Wash Aug 6 2008 Microsoft Corp today announced the release to manufacturing of Microsoft SQL Server 2008 the new version of the company s acclaimed data management and business intelligence platform This version of SQL Server provides powerful new capabilities such as support for policy based management auditing large scale data warehousing geospatial data and advanced Community Day sessions available online The sessions we organized on the Community Day last June are available online on Chopsticks Nieuwe Data Types in SQL Server 2008 Werner Geuens Why Upgrade to SQL Server 2008 Top 10 feautures 10 demos Frederik Vandeputte presentation of Michel Ulens about Linked Server is available The presentation together with the scripts used by Michel Ulens in the UG evening of March 27 are available here SQL Server 2008 RC0 released Microsoft released RC0 of SQL Server 2008 to the public The download is available on connect microsoft com Presentation Managing Sql Server 2005 using free utilities available Presentation about Managing Sql Server 2005 using free utilities by Dirk Gubbels on the UG evening of May 29 2008 is available here scripts about Linked Server session available The scripts used by Michel Ulens in the UG evening of March 27 are available here Full House for our next UG evening A lot of people registered for the next UG evening on May 29th so we had to close the registration earlier than foreseen Sorry for the inconvenience Next UG evening on Thu May 29 Dirk Gubbels on Managing monitoring and troubleshooting SQL Server using Free tools Managing monitoring and troubleshooting SQL Server using Free tools given by Dirk Gubbels Microsoft Abstract Out of the box SQL Server 2005 offers nice tools for managing and monitoring servers and databases If you want to get an even richer experience and a broader toolset there are a lot of hidden gems out there free for you to download and to make the life of the DBA easier Thi Microsoft TechNet Briefing Security Strategies with Steve Riley This TechNet Briefing is organised by Microsoft Belux Speaker Steve Riley Senior Security Strategist Microsoft Corportation When May 27th full day event Where Utopolis Mechelen Audience IT Professionals Security TDMs Registration Link https msevents microsoft com CUI EventDetail aspx EventID 1032378435 Culture en US Event Overview It s 11 Location is known for next UG Evening on May 29 Thank you Global Knowledge for hosting our next UG Evening on May 29 about Managing monitoring and troubleshooting SQL Server using Free tools given by Dirk Gubbels Microsoft For more info on the exact location in Mechelen please click here See you there Pervasive Business Intelligence The presentation of our vice president Frederik Vandeputte given on Techdays 2008 is available here April Edition of TechNet Magazine Online SQL Server 2008 What s New The new version of SQL Server offers a host of new features and enhancements that promise to improve performance increase security and make life better for database administrators Here s an overview of the key changes and what you can expect from SQL Server 2008 SQL Server 2008 Security Security continues to be an area of deliberate improvement for SQL Ser http sqlug be blogs official sqlugbe blog archive 2007 12 06 registration open for ug evening about technical overview of sql server 2008 aspx PingBack from http frankthefrank info entry php id kwws 3d22vtoxj1eh2eorjv2riilfldobvtoxjehbeorj2dufklyh2533 3a2452392uhjlvwudwlrq0rshq0iru0xj0hyhqlqj0derxw0whfkqlfdo0ryhuylhz0ri0vto0vhuyhu0533 3b1dvs 7b Registration for the next UG evening will be closed in a few hours Registration for our next UG evening will be closed in a few hours If you are attending you have to register Job Announcements from our Gold Sponsors Our Gold Sponsors Kohera and Ordina have vacancies Read more here TechDays 2008 Early Bird discount ends on January 31 Microsoft gives a 15 Early Bird Discount for the TechDays 2008 until the end of January So for 289 EUR you get two full days of technical content by top speakers and the chance to connect with the TechNet and MSDN communities Take advantage of the Early Bird offer and register before January 31 SQLUG Ordina Technical overview of SQL Server 2008 laquo Wats Buggin Me PingBack from http jummu14 wordpress com 2008 01 24 sqlug ordina technical overview of sql server 2008 Pictures From The SQLUG Katmai 2008 Event Sven Cipido brought his camera along to the latest meeting and made some excellent shots view them on his flicker stream Bart Bultinck Presentation of the UG evening of January 17 2008 is available Gunther Beersaert s presentation about a Technical Overview of Sql Server 2008 is available here Thank you Gunther And the winner of the free ticket for TechDays 2008 is We are happy to announce that Bart Michiels won a free ticket sponsored by Microsoft Belux for TechDays 2008 on March 12 and 13 Registration for UG evening Thu January 17 will be closed The registration for the UG evening of Thu January 17 by Gunther Beersaerts about Technical Overview of Sql Server 2008 will be closed this evening Please register before 19 00 if you want to attend Thank you MSDN Blog Postings raquo Belgian SQL Server User Group Meeting on SQL Server 2008 PingBack from http msdnrss thecoderblogs com 2007 12 27 belgian sql server user group meeting on sql server 2008 Belgian SQL Server User Group Meeting on

    Original URL path: http://sqlug.be/announcements (2016-04-30)
    Open archived version from archive


  • Announcements - SQL Server Performance Tuning Workshop by SQL Passion - April 11-15, Utrecht - SQLUG.be
    with a dive into the PDW Unravelling SQL 2014 In Memory OLTP Your backups high and dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Announcements SQL Server Performance Tuning Workshop by SQL Passion April 11 15 Utrecht Are you a SQL Server DBA or developer and you have encountered performance related problems with SQL Server Yesterday our SQL Server was running very smoothly but today s performance is very bad and you have no idea what the problem is nor how to solve it Because of that reason in April 2015 we run our SQL Server Performance Tuning Troubleshooting Workshop in Utrecht Netherlands to help you to react in situations like the above The training is perfect for people who Are responsible for SQL Server installations that are performance critical Have performance problems and want to know techniques and approaches how to troubleshoot and fix them Want to have a better understanding about

    Original URL path: http://sqlug.be/announcements/2016/03/sql-server-performance-tuning-workshop-by-sql-passion--april-1115,-utrecht (2016-04-30)
    Open archived version from archive

  • Announcements - UG Evening: Performance Troubleshooting Using Wait Statistics - 24/03/2016 - SQLUG.be
    2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Announcements UG Evening Performance Troubleshooting Using Wait Statistics 24 03 2016 On March 24th the one and only Paul Randal will be bring us a realtime video session on how to troubleshoot performance using wait statistics One of the first things you should check when investigating performance issues are wait

    Original URL path: http://sqlug.be/announcements/2016/02/ug-evening-performance-troubleshooting-using-wait-statistics (2016-04-30)
    Open archived version from archive

  • Announcements - UG Evening: Power BI - From Personal BI to Personal Data Science - 08/12/2015 - SQLUG.be
    Data vs Many data with a dive into the PDW Unravelling SQL 2014 In Memory OLTP Your backups high and dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Announcements UG Evening Power BI From Personal BI to Personal Data Science 08 12 2015 Microsoft states that Power BI is a cloud based business

    Original URL path: http://sqlug.be/announcements/2015/11/ug-evening-power-bi-from-personal-bi-to-personal-data-science (2016-04-30)
    Open archived version from archive

  • Announcements - UG Evening: Spark on Azure: A Gentle Introduction & Data Factory introduction - 26/11/2015 - SQLUG.be
    Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Announcements UG Evening Spark on Azure A Gentle Introduction Data Factory introduction 26 11 2015 Spark on Azure A Gentle Introduction A gentle introduction to the world of Big Data and Spark We are going to use Spark notebooks Jupyter and Zeppelin which are available on Azure HDInsight to demonstrate the ideal ad hoc data analytics environment right from within your browser

    Original URL path: http://sqlug.be/announcements/2015/11/ug-evening-spark-on-azure-a-gentle-introduction-data-factory-introduction (2016-04-30)
    Open archived version from archive

  • SQLUG.be
    on May 2nd 4th and running a full day pre conference focusing on Azure SQL Database SQLCAT A Day in the life of an Azure SQL DB Developer DBA DevOps In this demo rich session we will cover various aspe Source SQL Server Customer Advisory Team 19 04 2016 18 56 Stats Week Statistics Terminology Cheatsheet These things used to confuse me so much Despite having worked at a Market Research company for a while I know nothing about statistics other than that project managers have all sorts of disagreeably subjective phrases for describing them Vast 82 Source Brent Ozar Unlimited 19 04 2016 15 15 Video Free Training of the Week Statistics and Memory Grants This week is Stats Week here at Brent Ozar Unlimited so let s kick things off with a module from How to Think Like the Engine Why does one query get wildly different execution plans In this 17 minute video learn how statistics Conti Source Brent Ozar Unlimited 18 04 2016 14 45 SQL Server 2016 Release Candidate 3 now available We are excited to announce that our fourth and final SQL Server 2016 release candidate SQL Server 2016 Release Candidate RC 3 is now available for download Our SQL Server Release Candidates represent important milestones in the release of SQL Se Source SQL Server Blog 15 04 2016 19 00 Video Office Hours 2016 04 13 This week Jessica Richie and Tara discuss whether you should skip SQL Server 2014 and jump to 2016 our Performance Tuning When You Can t Fix the Queries class and whether you should detach a database in order to drop the connections to 8 Source Brent Ozar Unlimited 15 04 2016 14 15 sp whoisactive for Azure SQL Database Attempt 2 Over a year ago now I announced a rough port of sp whoisactive to Azure SQL Database This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs until Microsoft decided to rip out one of the key DMVs sys dm os sys inf Source Adam Machanic s Blog 14 04 2016 20 32 sp whoisactive for Azure SQL Database Attempt 2 Over a year ago now I announced a rough port of sp whoisactive to Azure SQL Database This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs until Microsoft decided to rip out one of the key DMVs sys dm os sys inf Source Adam Machanic s Blog 14 04 2016 20 32 sp whoisactive for Azure SQL Database Attempt 2 Over a year ago now I announced a rough port of sp whoisactive to Azure SQL Database This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs until Microsoft decided to rip out one of the key DMVs sys dm os sys inf Source Adam Machanic s Blog 14 04 2016 20 32 sp whoisactive for Azure SQL Database Attempt 2 Over a year ago now I announced a rough port of sp whoisactive to Azure SQL Database This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs until Microsoft decided to rip out one of the key DMVs sys dm os sys inf Source Adam Machanic s Blog 14 04 2016 20 32 Announcing Our New Pre Con Performance Tuning When You CAN Fix the Queries Going to be in the Seattle area in October Are your users frustrated because the app is too slow and you can change the SQL queries but you re not sure how Or which ones Or where to start Take heart Continue reading Source Brent Ozar Unlimited 14 04 2016 15 15 Looking for a New Challenge kCura is Hiring a DBA I m a big kCura Relativity fan it s an application that really pushes SQL Server hard written by people who are a ton of fun to work with If you re looking for a challenge in a really cool environment check out Co Source Brent Ozar Unlimited 14 04 2016 12 50 Keep data virtually forever with Stretch Database in SQL Server 2016 This post was authored by Joe Young Sr Program Manager SQL Server Stretch Database in SQL Server 2016 allows users to keep as much data as they need for as long as they need without incurring business service level agreement SLA risks or the Source SQL Server Blog 13 04 2016 19 30 Microsoft releases the latest update to Analytics Platform System APS Microsoft is pleased to announce the release of Analytics Platform System APS Appliance Update AU 5 APS is Microsoft s scale out Massively Parallel Processing fully integrated system for data warehouse specific workloads Powered by industry lea Source SQL Server Blog 13 04 2016 19 00 Old and Busted DBCC Commands in 2016 I hate DBCC Commands Not what they do just that the syntax isn t consistent do I need quotes around this string or not the results are a distraction to get into a usable table and you need to write absurd Continue reading Source Brent Ozar Unlimited 13 04 2016 15 15 Beyond end of support Seeing value in modernization This post was authored by Tiffany Wissner Senior Director Product Marketing Today is the last day of extended support for SQL Server 2005 Starting tomorrow companies running SQL Server 2005 will no longer receive security updates or hotfixes fro Source SQL Server Blog 12 04 2016 18 00 How to Run DBCC CHECKDB for In Memory OLTP Hekaton Tables tl dr run a copy only full backup of the Hekaton filegroup to nul If the backup fails you have corruption and you need to immediately make plans to either export all your data or do a restore from your last good Continue reading Source Brent Ozar Unlimited 12 04 2016 13 45 Mark your calendar Satya Nadella to keynote Microsoft Ignite in Atlanta We re pleased to announce that Microsoft CEO Satya Nadella will deliver

    Original URL path: http://sqlug.be/news/category/communityhomepage (2016-04-30)
    Open archived version from archive

  • SQLUG.be
    s an application that really pushes SQL Server hard written by people who are a ton of fun to work with If you re looking for a challenge in a really cool environment check out Co Source Brent Ozar Unlimited 14 04 2016 12 50 Old and Busted DBCC Commands in 2016 I hate DBCC Commands Not what they do just that the syntax isn t consistent do I need quotes around this string or not the results are a distraction to get into a usable table and you need to write absurd Continue reading Source Brent Ozar Unlimited 13 04 2016 15 15 How to Run DBCC CHECKDB for In Memory OLTP Hekaton Tables tl dr run a copy only full backup of the Hekaton filegroup to nul If the backup fails you have corruption and you need to immediately make plans to either export all your data or do a restore from your last good Continue reading Source Brent Ozar Unlimited 12 04 2016 13 45 Video Free Training of the Week Dynamic Quorum and Dynamic Witness In this week s free video training sample dig into the details of dynamic quorum and dynamic witness what do they do What s strange about them at small node counts in a cluster You ll also learn how to configure quorum in 8230 Source Brent Ozar Unlimited 11 04 2016 15 40 Breaking News Literally SQL CLR Support Removed from Azure SQL DB In the on premises boxed product version of SQL Server you can build your own CLR assemblies and call them from your T SQL code For years this feature was missing from Azure SQL DB Microsoft s platform as a service database offering Source Brent Ozar Unlimited 08 04 2016 18 36 Video Office Hours 2016 04 06 This week Brent Erik Jessica and Richie discuss the sudden increase in AWS cloud clients whether you should use cardinality estimator hints how to do indexing on a former SQL Server 2000 database and Brent s hilarious Jerusalem tour guid Source Brent Ozar Unlimited 08 04 2016 16 15 Another Hidden Parallelism Killer Scalar UDFs In Check Constraints Every single time Really Every single time It started off kind of funny Scalar functions in queries no parallelism Scalar functions in computed columns no parallelism even if you re not selecting the computed column Every time I think o Source Brent Ozar Unlimited 07 04 2016 15 15 I m on the RunAsRadio Podcast It s always fun to talk to Richard Campbell about what s going on and this time around it s SQL Server 2016 Listen to me chat with Richard about what s coming in vNext We re now in the second quarter of the year 8 Source Brent Ozar Unlimited 06 04 2016 17 19 For Technical Interviews Don t Ask Questions Show Screenshots When you re hiring a DBA sysadmin or developer you re not paying them to answer Trivial Pursuit questions all day long You re hiring them to look at a screen connect a few dots and interpret what s happening So for a po Source Brent Ozar Unlimited 06 04 2016 15 15 ISNULL vs COALESCE What The XML This isn t about performance If you re interested in performance tests you can get in the way back machine and read a couple posts by Adam Machanic here and here I m also not talking about the difference between them There are Source Brent Ozar Unlimited 05 04 2016 15 15 SQL Server 2005 support ends next week Here s my tribute to it I remember the first time I used SQL Server 2005 I was a database administrator working on a new build data warehouse project in Miami Both our data warehouse and SQL Server 2005 were looking like they were going to come Continue reading Source Brent Ozar Unlimited 04 04 2016 15 45 Video Office Hours 2016 03 30 This week Angie Erik Jessica and Richie field a wide variety of questions but most importantly Erik shows his SQL Server 2016 Release Party Dance Here s the video on YouTube You can register to attend next week s Office Hours or Source Brent Ozar Unlimited 02 04 2016 16 15 Microsoft Discontinues SQL Server Support for Windows Microsoft announced today that the forthcoming SQL Server 2016 version won t just run on Linux it will only run on Linux When we started developing the Linux port of SQL Server we weren t really serious about it at all Source Brent Ozar Unlimited 01 04 2016 14 15 Announcing MailOrderDBAs com Are you tired of trying to find a database administrator in your own home town Tired of hearing DBAs tell you no over and over again Want to meet someone exotic who will say yes to your change requests Or Continue reading 8 Source Brent Ozar Unlimited 01 04 2016 08 00 Happy Fifth Birthday to Us 50 Off for You Five years ago we turned BrentOzar com into a consulting and training company Now look at us Well maybe not too closely we re getting a little gray and wrinkly To celebrate Video classes are now 50 off with coupon code HighFive That i Source Brent Ozar Unlimited 31 03 2016 15 15 Indexes Helping Indexes This post isn t going to solve any problems for you It was just something I stumbled on that struck me as funny while working on a demo for something else Brent didn t believe it at first so I thought I d Continue reading Source Brent Ozar Unlimited 30 03 2016 15 30 Psst Hey buddy you want some E Discovery One year ago today Well sort of one year ago Who knows when this thing will get published Only God and Brent And part of the calendar year fell during a leap year which was just plain cruel like a Continue reading Upcoming webc Source Brent Ozar Unlimited 29 03

    Original URL path: http://sqlug.be/news/source/brent-ozar-unlimited (2016-04-30)
    Open archived version from archive

  • SQLUG.be
    retrieves information from the sys query store query text query store catalog view the sys query store query query store catalog view the s Source Glenn Berry 31 01 2016 21 29 SQL Server Diagnostic Information Queries Detailed Day 30 For Day 30 of this series we start out with Query 67 which is UDF Statistics This query retrieves information from the sys dm exec function stats dynamic management view about aggregate runtime metrics for user defined functions in the current da Source Glenn Berry 30 01 2016 00 34 SQL Server Diagnostic Information Queries Detailed Day 29 For Day 29 of this series we start out with Query 65 which is XTP Index Usage This query retrieves information from the sys dm db xtp index stats dynamic management view and the sys indexes object catalog view about the overall in memory OLTP ind Source Glenn Berry 29 01 2016 17 27 SQL Server Diagnostic Information Queries Detailed Day 28 For Day 28 of this series we start out with Query 63 which is Overall Index Usage Reads This query retrieves information from the the sys indexes object catalog view and the sys dm db index usage stats dynamic management view about the overall Source Glenn Berry 28 01 2016 17 12 SQL Server Diagnostic Information Queries Detailed Day 27 For Day 27 of this series we start out with Query 61 which is Volatile Indexes This query retrieves information from the sys objects object catalog view the sys stats object catalog view and the sys dm db stats properties dynamic management fun Source Glenn Berry 27 01 2016 17 51 SQL Server Diagnostic Information Queries Detailed Day 26 For Day 26 of this series we start out with Query 59 which is Table Properties This query retrieves information from the sys tables object catalog view and the sys partitions object catalog view about various table properties in the current data Source Glenn Berry 26 01 2016 18 14 SQL Server Diagnostic Information Queries Detailed Day 25 For Day 25 of this series we start out with Query 57 which is Buffer Usage This query retrieves information from the sys allocation units object catalog view the sys dm os buffer descriptors dynamic management view and the sys partitions object Source Glenn Berry 25 01 2016 20 28 SQL Server Diagnostic Information Queries Detailed Day 24 For Day 24 of this series we start out with Query 54 which is Bad NC Indexes This query retrieves information from the sys dm db index usage stats dynamic management view and the sys indexes object catalog view about non clustered indexes that ha Source Glenn Berry 24 01 2016 20 29 SQL Server Diagnostic Information Queries Detailed Day 23 For Day 23 of this series we start out with Query 52 which is SP Logical Writes This query retrieves information from the sys procedures object catalog view and the sys dm exec procedure stats dynamic management view about the cached stored proce Source Glenn Berry 23 01 2016 23 51 SQL Server Diagnostic Information Queries Detailed Day 22 For Day 22 of this series we start out with Query 50 which is SP Logical Reads This query retrieves information from the sys procedures object catalog view and the sys dm exec procedure stats dynamic management view about the cached stored proced Source Glenn Berry 23 01 2016 23 29 SQL Server Diagnostic Information Queries Detailed Day 21 For Day 21 of this series we start out with Query 48 which is SP Avg Elapsed Time This query retrieves information from the sys procedures object catalog view and the sys dm exec procedure stats dynamic management view about the cached stored pro Source Glenn Berry 21 01 2016 18 00 SQL Server Diagnostic Information Queries Detailed Day 20 For Day 20 of this series we start out with Query 46 which is Query Execution Counts This query retrieves information from the sys dm exec query stats dynamic management view the sys dm exec sql text dynamic management function and the sys dm e Source Glenn Berry 20 01 2016 18 07 SQL Server Diagnostic Information Queries Detailed Day 19 After eighteen days of queries we have made it through all of the instance level queries in this set Now we move on to the database specific queries in the set For these queries you need to be connected to a particular database that you are conc Source Glenn Berry 20 01 2016 02 06 CPU Z Benchmark Survey The latest version of the free CPU Z utility has a quick CPU benchmark test that just takes a couple of minutes to run As part of a personal project that I am working on which I think will be very interesting and beneficial to the community I am Source Glenn Berry 19 01 2016 18 18 SQL Server Diagnostic Information Queries Detailed Day 18 For Day 18 of this series we start out with Query 41 which is Memory Clerk Usage This query retrieves information from the sys dm os memory clerks dynamic management view about total memory usage by your active memory clerks Query 41 is shown i Source Glenn Berry 18 01 2016 21 03 SQL Server Diagnostic Information Queries Detailed Day 17 For Day 17 of this series we start out with Query 39 which is PLE by NUMA Node This query retrieves information from the sys dm os performance counters dynamic management view about your page life expectancy PLE by NUMA node Query 39 is shown Source Glenn Berry 17 01 2016 19 31 SQL Server Diagnostic Information Queries Detailed Day 16 For Day 16 of this series we start out with Query 37 which is CPU Utilization History This query retrieves information from the somewhat undocumented sys dm os ring buffers dynamic management view about recent CPU utilization by SQL Server Query Source Glenn Berry 16 01 2016 16 59 SQL Server Diagnostic Information Queries Detailed Day 15 For Day

    Original URL path: http://sqlug.be/news/source/glenn-berry (2016-04-30)
    Open archived version from archive