Search Results

Search found 42327 results on 1694 pages for 'microsoft sql t sql'.

Page 246/1694 | < Previous Page | 242 243 244 245 246 247 248 249 250 251 252 253  | Next Page >

• Understanding T-SQL Expression Short-Circuiting

  Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it." Jonathan Allen. Download a free trial now.

  Read the article

• Une société française spécialisée dans la sécurité critique violemment Microsoft, un ingénieur de Google la soutient

  Une société française spécialisée dans la sécurité critique violemment Microsoft Un ingénieur de Google la soutient Mise à jour du 18/02/11 Travis Ormandy semble passer beaucoup de temps à scruter tout ce qui touche à la sécurité de Microsoft. L'ingénieur de Google avait suscité la colère des responsables de Microsoft en publiant une preuve de faisabilité (PoC) seulement 5 jours après avoir découvert une faille critique dans Windows (lire par ailleurs) Après cette polémique et les critiques contre Ormandy,

  Read the article

• Auditing made easy by Microsoft SQL Server 2008

  Microsoft SQL Server 2008 made the life of a DBA easier by providing an enhanced auditing feature, "SQL Server Audit". The first article of this series illustrates the various components for auditing and the action groups provided by Microsoft SQL Server 2008.

  Read the article

• Database Maintenance Scripting Done Right

  - by KKline

  I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating...(read more)

  Read the article

• Getting Started with Columnstored Index in SQL Server 2014 – Part 2

  Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests.

  Read the article

• Free book from Microsoft on on Office 365

  - by TATWORTH

  At http://blogs.msdn.com/b/microsoft_press/archive/2011/08/17/free-ebook-microsoft-office-365-connect-and-collaborate-virtually-anywhere-anytime.aspx  you can get a free book from Microsoft on Office 365 (Epub and mobi formats are available at http://blogs.msdn.com/b/microsoft_press/archive/2011/09/23/free-ebook-microsoft-office-365-connect-and-collaborate-virtually-anywhere-anytime-now-in-more-formats.aspx)

  Read the article

• Windows Phone : Nokia et Microsoft organisent des formations gratuites à Rennes, Bordeaux, Strasbourg et Lyon

  Windows Phone : Nokia et Microsoft organisent des journées de formation gratuites A Rennes, Bordeaux, Strasbourg et Lyon Nokia et Microsoft ont bien compris que le succès d'une plateforme tient aussi, et surtout, et à sa communauté de développeurs. Windows Phone 7.5 (Mango) ne fait pas exception et les deux géants IT ont donc décidé de lancer une série de journée de formations gratuites dédiées au développement sous l'OS mobile de Microsoft. Ces journées se dérouleront à Rennes, Bordeaux, Strasbourg et Lyon, jusqu'à début décembre. Elles aborderont entre autre, la conception d'applications avec Visual Studio 2010 et Silverlight, le cycle de vie des applications

  Read the article

• Southampton SQL Server User Group–February 2011

  - by GavinPayneUK

  Earlier this week I attended the second sitting of the Southampton SQL Server user group, one of the regional events which compliments the larger SQL Server events we put in our diaries. The event is very well organised by Mark Pryce-Maher ( twitter ), Matt Whitfield ( twitter ) and Adrian Hills ( twitter ) in an easy to find Southampton church hall room with drinks and pizza supplied in addition to quality time with fellow SQL Server peers.  Thanks must also go to another of the event’s supporters...(read more)

  Read the article

• Microsoft met de la BI dans son ERP, et du Windows 8 dans son CRM Online

  Microsoft met de la BI dans son ERP Et du Windows 8 dans son CRM Online Microsoft met à jour sa gamme Dynamics 2012 avec deux nouveautés. Première annonce, la sortie de la version R2 de Dynamics AX 2012 - un de ses deux ERP maison avec Dynamics NAV (qui vise plus les PME/PMI). Cette version pour les moyennes et grandes entreprises introduit des fonctionnalités de Business Intelligence basées sur Microsoft SQL Server. « Grâce à elles, des informations importantes concernant toutes les activités de l'entreprise, peuvent être exploitées rapidement, de manière intuitive et contextuelle en fonction des requêtes de l'utilisateur », avance Microsoft. Elle proposera é...

  Read the article

• Microsoft Web Camps in Moscow, Beijing, Shanghai this Week

  Microsoft Web Camps are free, two-day events where you can learn about the latest components of the Microsoft Web Platform, work with hands-on labs, build solutions in teams, and have direct interaction with Microsoft experts. Technologies covered include ASP.NET, Visual Studio, IIS and more. Register today....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

  Read the article

• The EXCEPT and INTERSECT Operators in SQL Server

  The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it." Jonathan Allen. Download a free trial now.

  Read the article

• SQL Injection prevention

  - by simonsabin

  Just asking people not to use a list of certain words is not prevention from SQL Injection https://homebank.sactocu.org/UA2004/faq-mfa.htm#pp6 To protect yourself from SQL Injection you have to do 1 simple thing. Do not build your SQL statements by concatenating values passed by the user into a string an executing them. If your query has to be dynamic then make sure any values passed by a user are passed as parameters and use sp_executesql in TSQL or a SqlCommand object in ADO.Net...(read more)

  Read the article

• Microsoft annonce les prochaines dates de sortie de SQL Server, version 2005 (SP4) et 2008 (SP2)

  Mise à jour du 29.03.2010 par Katleen Microsoft dévoile les prochaines dates de sortie de SQL Server, version 2005 (SP4) et 2008 (SP2) L'équipe travaillant sur SQL Serveur vient de publier un billet assez succinct sur son blog, à propos des prochains services packs à sortir. Ces road maps indiquent uniquement les dates de sortie, et pas encore les contenus. SQL Server 2005 (SP4) sera disponible au cours du dernier trimestre 2010, il s'agira du dernier service pack pour cette version. SQL Server 2008 (SP2) devrait sortir lors du troisième trimestre 2010 Plus d'informations à venir sur ces deux sorties bientôt, notamment à propos de leurs contenus. A...

  Read the article

• Blogging from the PASS Summit : Nov. 7th keynote

  - by AaronBertrand

  Bill Graziano takes the stage at 8:15. He talks about how 3,894 attendees (and 5,611 total registrants) represent 57 countries at the 14th summit. There are over 127,000 members worldwide. Note that you can watch the keynotes and many sessions through Pass TV . PASS serves SQL Server community - expertise, support, commitment. He talks about SQL Saturdays, SQL Rally, 24 Hours of PASS, and the Summit. He announces that there will be a third annual SQL Rally Nordic event next November, and that there...(read more)

  Read the article

• TechEd 2010 Followup

  - by AllenMWhite

  Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented: DAT01-INT Administrative Demo-Fest for SQL Server 2008 SQL Server 2008 provides a wealth of features aimed at the DBA. In this demofest of features we'll see ways to make administering SQL Server easier and faster such as Centralized Data Management, Performance Data Warehouse, Resource Governor, Backup Compression...(read more)

  Read the article

• Red Gate Software announces speaker line up for US SQL in the City tour

  SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle. Compress live data by 73% Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.

  Read the article

• Database recovery model change notification report for SQL Server

  The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected. The Future of SQL Server MonitoringMonitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

  Read the article

• Microsoft publie le Patch Tuesday du mois d'avril, qui corrige 11 failles de sécurité

  Microsoft publie le Patch Tuesday du mois d'avril Qui corrige 11 failles de sécurité Le Patch Tuesday survient le deuxième mardi de chaque mois ; Microsoft publie des correctifs de sécurité à destination de ses clients. Les bulletins sont qualifiés Faible, Modéré, Important ou Critique. Le Patch Tuesday du mois d'avril 2012 comporte six bulletins (du MS12-023 au MS12-028) qui corrigent 11 vulnérabilités. Quatre d'entre eux sont qualifiés de "critique" par l'éditeur (contre un seul le mois dernier). Un bulletin concerne les systèmes Microsoft Windows, un second concerne Internet Explorer, un troisième le Framework .NET et le dernier concerne Microsoft Office, Micr...

  Read the article

• T-SQL Quiz 2011

  The 2011 edition of MVP Jacob Sebastian's T-SQL Quiz is underway. You can take part in the quiz each day, submitting your answers for the chance to show off your knowledge and perhaps win some prizes. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it." Jonathan Allen. Download a free trial now.

  Read the article

• SQL Server stored procedure to generate random passwords

  SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications. Get Smart with SQL Backup Pro Powerful centralised management, encryption and more.SQL Backup Pro was the smartest kid at school Discover why.

  Read the article

• T-SQL Tuesday #006 Round-up!

  - by Mike C

  T-SQL Tuesday this month was all about LOB (large object) data. Thanks to all the great bloggers out there who participated! The participants this month posted some very impressive articles with information running the gamut from Reporting Services to SQL Server spatial data types to BLOB-handling in SSIS. One thing I noticed immediately was a trend toward articles about spatial data (SQL Server 2008 Geography and Geometry data types, a very fun topic to explore if you haven’t played around with...(read more)

  Read the article

• SQL Down Under Podcast - Gadi Peleg - Data Quality Services

  - by Greg Low

  Well it's been a few months but I'm back on a roll creating some SQL Down Under podcasts. The first out the door is an interview with Gadi Peleg from the SQL Server team, introducing Data Quality Services.Gadi came to Microsoft when Zoomix was acquired.Details of this podcast (and other available podcasts) are here: http://www.sqldownunder.com/Resources/Podcast.aspxHope you enjoy it even though there are some telling signs that I recorded it at 3AM :-)If you are using iTunes, you can also subscribe here: http://itunes.apple.com/au/podcast/sql-down-under/id503822116?mt=2

  Read the article

• Improving 2D Range Query Performance in SQL Server

  When using the BETWEEN operator on multiple columns, you are likely using a 2D range query. Such queries perform very poorly in SQL Server. This article examines rewriting these queries for improved performance. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it." Jonathan Allen. Download a free trial now.

  Read the article

• Upgrading from Express Edition to Standard Edition

  - by TiborKaraszi

  Say you encounter an SQL Server which is Express Edition, and it really should have been some higher edition. Sounds familiar? It is common for me as a consultant to find plenty of SQL Servers at a customer's site. Many of the databases in these will be moved (typically using backup and restore) to a "real" SQL Server. But in some cases, this might not be desirable. You want to convert the whole instance, from Express to a "real" SQL Server edition. I'm attending a great SharePoint course for Daniel...(read more)

  Read the article

• My Last Day at Microsoft

  Wow I cant believe it has already been 13 years at Microsoft.  I have had a great time here and learned so much from the smart and passionate people I work with as well as the incredible developer community around .NET.  But I have decided it is time for me to try something new so my last day at Microsoft will be Friday, April 23rd .  While I am leaving Microsoft, I continue to have a positive view of the company.   No other company has the footprint that Microsoft does...Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

  Read the article

< Previous Page | 242 243 244 245 246 247 248 249 250 251 252 253  | Next Page >