sqlblog.com

Please wait for loading...




      (1555):

    /
     1  +1 2014 jul 30microsoft semantic engineJamie Thomson : Microsoft Semantic Engine uncovered – the A few weeks ago I wrote a blog entry entitled Microsoft Semantic Engine where I spoke about a technology called (unsurprisingly) the “Microsoft ...
     1  +1 2014 jul 17web excel pivotJamie Thomson : Using Pivot tables in the Office Excel Web AppOne new feature that piqued my interest was that pivot tables and slicers are now displayed in the Excel Web App on SkyDrive and, even better ...
     2  ~ 2014 sep 30sql server script dataEric Johnson : Script Data in SQL Server 2008 - SQLblog.comHere is a feature that I have been waiting for since I started working with SQL Server 6.5; the ability to script the data from a table. When you ...
     2  +3 2014 sep 21sql server maxmemoryTibor Karaszi : Setting max server memory - SQLblog .comIf there is one server setting that is close to universal to configure, then it is probably the " max server memory " setting. The setting is ...
     2  ~ 2014 sep 18if not existsMerrill Aldrich : IF NOT EXISTS ( SELECT 'thisPost' ) CREATE POST One basic principle that could help is to develop a habit of using the “ IF NOT EXISTS ” or “CREATE OR ALTER” patterns in these scripts.
     2  ~ 2014 sep 01alberto ferrariAlberto Ferrari - SQLblog.comAt the end of June 2012, I was in Amsterdam to present some sessions at Teched Europe 2012 and, while preparing the material for the demos ...
     3  +5 2014 sep 30sql hotmail gmail passwordSetting up Database Mail to use Gmail account for ... - SQLblog .comThis past weekend's SQL Saturday #31 in Tampa, FL I had the need to send email
     3  ~ 2014 sep 12symmetric encryption using smoAllen White : What Encryption Algorithms Are You Using ?Smo .Server') 'MyServer\MyInstance'. Then, I iterate through the ... the key name and algorithm, then do the same thing for the symmetric keys.
     4  +4 2014 sep 17how to change sql variableIncrement a variable in the SET clause of an ... - SQLblog .comIncrement a variable in the SET clause of an UPDATE statement [T- SQL ]. There's a very nifty feature of T- SQL that, in my experience, not ...
     4  ~ 2014 aug 27sql server betweenWhat do BETWEEN and the devil have in common? - SQLblog .comAnother incorrect assumption people make about BETWEEN , specifically when dealing with DATE/TIME data types, is that SQL Server can ...
     4  +2 2014 aug 13version control by exampleA free book entitled " Version Control by Example " by ... - SQLblog.comI have just downloaded and started reading a free PDF book about version control systems (VCS), entitled Version Control by Example , written ...
     4  -1 2014 jul 22scalable shared databasesBenjamin Nevarez : Are You Using Scalable Shared Databases ?Did you know that you can share read-only databases between several instances of SQL Server? Scalable Shared Databases is a very ...
     4  ~ 2014 jul 22between sql server
     5  ~ 2014 sep 23google chart apiMaria Zakourdaev : Using Google Charts API to Visualize Schema Last week I have worked on the new email report using Google Charts and liked it so much that decided to share it here with anyone who finds ...
     5  ~ 2014 sep 12update fromLet's deprecate UPDATE FROM ! - SQLblog.comI guess that many people using UPDATE … FROM on a daily basis do so without being aware that they are violating all SQL standards.
     5  +5 2014 sep 10sql disaster recoveryHave you ever tried to recover from a disaster ... - SQLblog .comcustomers recover using SQL Server, Paul S. Randal of SQLskills.com has produced this disaster recovery poster for SQL Server Magazine. The poster shows ...
     5  -2 2014 sep 03sql server blogSQLblog.com - The SQL Server blog spot on the webSQL Blog - Blogs about SQL Server , T-SQL, CLR, Service Broker, Integration Services, Reporting, Analysis Services, Business Intelligence, ...
     5  +3 2014 aug 21sql server functionsT- SQL User-Defined Functions : the good, the bad ... - SQLblog .comSo you thought that encapsulating code in user-defined functions for easy reuse is a good idea? Think again! SQL Server supports three types ...
     5  +8 2014 aug 03ms sql functionSQL Server supports three types of user-defined functions . ... the query without function , if only by a little bit – 47 ms CPU and 50 ms elapsed on ...
     5  ~ 2014 aug 01access free reporting toolDavide Mauri : Peeble Reports – Free reporting Tool - SQLblog.comPeeble Reports – Free reporting Tool ... and now it clearly says: Send your full name to pebble@pebblereports.com to get a free license key.
     5  -2 2014 jul 22sql server tape backupBackup TO DISK, TAPE and now URL - Backup On ... - SQLblog .comBackup TO DISK, TAPE and now URL - Backup On-Premises SQL Server Databases to Azure Storage. There has been a lot of discussion over ...
     5  ~ 2014 jul 20sql server create functionSQL Server supports three types of user-defined functions . ... Let's first take a look – in order to test the performance, I'll create a table with ...
     6  -2 2014 oct 03update from whereLet's deprecate UPDATE FROM! - SQLblog.com
     6  -3 2014 sep 25sql update fromLet's deprecate UPDATE FROM ! - SQLblog .com
     6  -1 2014 sep 22tribal tuningBook Review: Tribal SQL,Performance Tuning With ... - SQLblog.comBook Review: Tribal SQL,Performance Tuning With SQL Trace and Extended Events. Tara Kizer wrote this chapter, and it is relevant for us ...
     6  ~ 2014 sep 21lun disk queue sql serverJoe Chang : IO Queue Depth Strategy - SQLblog .comThen the SQL Server IO queue depth policy is reviewed. ..... The number of disks behind each LUN is not considered, the useage model (OLTP ...
     6  +3 2014 aug 30server migration checklistMerrill Aldrich : Server Migration Checklist - SQLblog.comDuring the past six months or so I have had to manage quite a lot of SQL Server migration /consolidation, and with each effort I've refined a ...
     6  +9 2014 jul 30select into varchar mssqlAaron Bertrand : Bad habits to kick : declaring VARCHAR without The point of my post was that in SQL Server , because when you ... Had to change that to " SELECT CONVERT( varchar ,ParameterValue) AS ...
     6  +6 2014 jul 20sql server viewerMerrill Aldrich : Public Release, SQL Server File Layout ViewerVersion 1.0 is Now Available! Edit 9 October 2013: A new version is out! Please download 1.2 from here . I've been working off and on, as my ...
     6  ~ 2014 jul 20distributor movign signMaria Zakourdaev : The Distributor . Think and Rethink every thing.Misconfiguration of the Distributor can lead to increased load on the production
     6  +1 2014 jul 18master data serviceMaster Data Services Team - SQLblog.comMicrosoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs.
     7  -2 2014 sep 29mvp deepRob Farley : SQL Server MVP Deep Dives Vol 2 – get my chapter freeRob Farley - Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL ...
     7  +53 2014 sep 01procedural writing keywordsAaron Bertrand : My stored procedure "best practices" checklistI just find if much more readable when all of the keywords are capitalized. ..... When writing multi-table queries, I don't give tables meaningless ...
     7  +1 2014 aug 15server memory leakTroubleshooting the SQL Server Memory Leak (or ... - SQLblog.comLearn how SQL Server allocates and uses the physical memory available on a server , as well as why SQL Server doesn't release memory like ...
     7  -3 2014 aug 04sql server replicatinRob Farley : SQL Replication demystified - SQLblog .comI spent some time explaining SQL Server Replication to someone recently. They said they hadn't ever really understood the concepts, and that ...
     7  -1 2014 aug 02create function sql server
     7  +2 2014 aug 01ssis best practicesJamie Thomson : Suggested Best Practises and naming conventionsI thought it would be worth publishing a list of guidelines that I see as SSIS development best practices . These are my own opinions and are ...
     7  +65 2014 jul 31access free reporting softwareIt's free (at least now) too. After Adam's comment, I double checked that the software is really free . ... your full name to pebble@pebblereports.com to get a free license key.
     8  +3 2014 sep 12postgresql updateAlexander Kuznetsov : Learning PostgreSql : UPDATE ...FROM works UPDATE ...FROM command on PostgreSql may raise no errors, but produce completely different results. Later I shall provide a repro, but first let ...
     8  +1 2014 aug 28full duplex ethernetJoe Chang : Gigabit Ethernet is Full - Duplex only! - SQLblog.comPeople still talk about checking if the network is in full - duplex mode even when they are on Gigabit Ethernet . Let me say clearly: Gigabit ...
     8  +4 2014 aug 27database connection testAndy Leonard : Quick Database Connectivity Testing - SQLblog.comIntroduction Ever find yourself needing to test connectivity , but you're on a machine with no client tools? It happens to me occasionally.
     8  -4 2014 aug 22sharepoint hampton roadsPresenting at Hampton Roads SQL Server and SharePoint User I am honored to present Using BIML as an SSIS Design Patterns Engine to the Hampton Roads SQL Server and SharePoint User Group ...
     8  +4 2014 aug 21test database connection
     8  +14 2014 aug 10rosetta stone updateAn update on using Rosetta Stone : Studio now isn't ... - SQLblog.comAn update for those considering Rosetta Stone (www. rosettastone .com) for Chinese, Spanish or any other language that they offer: I had to ...
     8  +6 2014 aug 03visual studio image libraryVisual Studio Image Library now available for ... - SQLblog.comIt's great to see that Microsoft have published an image library for Visual Studio that lets your own applications use the same images that they ...
     8  ~ 2014 aug 03replication in sql server
     8  +14 2014 aug 01sql maintenance utilityLinchi Shea : A DBA utility database in every SQL Server instance?The Management Instance has SQL Agent configured as a Master Server and .... One for utility which contain the typical generic maintenance  ...
     8  +1 2014 jul 31sql server pediaKevin Kline : New Developments at SQLServerPedia .comSince the news broke that I was leaving Quest, I've gotten a lot of questions about the future of SQLServerPedia .com (SSP). For those of you ...
     8  +3 2014 jul 21sql list managerClearing the Recent Servers List in SQL Server Management StudioUpdate: While I was away, Aaron Bertrand already blogged about this topic on the following link: ...
     9  -2 2014 sep 23sqldumperKevin Kline : SQLDumper - SQLblog.comSQLDumper is an internally called process that can produce a stack dump in mini , full, and filtered formats. Learn more about it here...
     9  +2 2014 sep 13wordpress sql serverDavide Mauri : Wordpress Installation (on IIS and SQL Server )To proceed with the installation of Wordpress on SQL Server and IIS, first of all, you need to do the following steps Create a database on SQL ...
     9  +10 2014 sep 12open multiple instances of excelSQLBI - Marco Russo : Running Excel 2013 in a separate instance These two add-ins are automatically installed but not enabled by default. ... Excel will ask you if you require opening Excel as a new instance .
     9  ~ 2014 sep 12sqlserver updateAaron Bertrand : SQL Server 2014 Cumulative Update #2 is AvailableMicrosoft has released Cumulative Update #2 for SQL Server 2014. Important! This Cumulative Update fixes the data loss / corruption issue ...
     9  +5 2014 sep 09events manager extended tablesExtended Events - SQLblog.comExtended Events demos on Microsoft Virtual Academy .... But from the table earlier in the post we know that wait_type 47 is not used, .... interface is built directly into management studio (SSMS) and that there are four parts:.
     9  +6 2014 sep 05events manager extended supportAn XEvent a Day (12 of 31) – Using the Extended Events SSMS AddinThe lack of SSMS support for Extended Events, coupled with the fact that a ... The Extended Events Manager exists in two forms, a SSMS Addin, ...
     9  +1 2014 sep 03events manager extendedThe Rambling DBA: Jonathan Kehayias : Extended Events Manager I published the beta build last week for an update to the Extended Events Manager that made a performance enhancement to the ...
     9  ~ 2014 sep 01nt authority systemQuestion: Is NT AUTHORITY \ SYSTEM a sysadmin in ... - SQLblog.comIf your SQL Server services run under a domain user account, is NT AUTHORITY \ SYSTEM (Local System) a sysadmin in your SQL Server and ...
     9  -1 2014 aug 24sql server replication
     9  -5 2014 aug 09sql server backup tabelsBackup a Single Table in SQL Server using SSMS - SQLblog.comOur buddy Buck Woody made an interesting post about a common question: " How do I back up a single table in SQL Server ?" That got me ...
     9  +9 2014 aug 05no excuses summit dbaThe Rambling DBA : Jonathan Kehayias : Closing out 2009 – Goals The random ramblings and rantings of frazzled SQL Server DBA ... at least one session at a major event, (ie TechEd, SQLConnections, PASS Summit , etc.) ... I never even scheduled the exam, so no excuses for this one.
     9  -2 2014 aug 03sql for xml pathHandling special characters with FOR XML PATH - SQLblog .comBecause I hate seeing > or & in my results… Since SQL Server 2005, we' ve been able to use FOR XML PATH ('') to do string ...
     9  +5 2014 aug 01functions in sql server
     9  -4 2014 aug 01sql server on ssdJoe Chang : SSD and Internal SQL Server Tuning StrategiesWith SSD at sufficient level of maturity and cost viability, it is possible to .... Reverse engineering the SQL Server Cost Based Optimizer (Query ...
     9  +1 2014 jul 31nehalem vs westmereJoe Chang : Intel Xeon 5600 ( Westmere -EP) and 7500 ( Nehalem In the performance world, no results almost always mean bad or not good ... Intel Xeon 5600 ( Westmere -EP) and 7500 ( Nehalem -EX) and AMD ...
     9  +10 2014 jul 26fqdn break down toolAdam Machanic : Database Mirroring: FQDNs are Your Friends!But now I added the witness server and suddenly things started breaking down . The mirror instance couldn't connect with the witness, and the ...
     9  +3 2014 jul 23latency testing simulationSimulating High Latency and Low Bandwidth in Testing of Database To simulate satellite latency in my test environment, I used a product from www. shunra.com called VE Desktop. It is a simple to use application ...
     10  +1 2014 oct 03update sql serverAaron Bertrand : February 2014 Cumulative Update for SQL Server Microsoft has released Cumulative Update #11 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2926028 12 fixes listed at time of ...
     10  ~ 2014 sep 28intel server sizingJoe Chang : Hardware Update 2014 and Server Sizing - SQLblog.comHardware Update 2014 and Server Sizing . Intel Xeon E7 v2 processors (Ivy Bridge-EX) officially launched today. The E5 v2 processors (Ivy ...
     10  -3 2014 sep 25string proceduresAaron Bertrand : Finding stored procedures containing % string %Having just returned from PASS, I needed to play catch up on a few things in a stored procedure that was being developed before I left. Being a ...
     10  -1 2014 sep 18linqpad reporting engineJamie Thomson : Linqpad – bring the power of LINQ to SQL Server ... I will) but in this blog post I want to shine a light on a tool called Linqpad . Linqpad enables you to issues queries written in LINQ against a database and ... The great thing about Linqpad is that it enables one to write LINQ queries .... sql server management studio · SQL Server Reporting Services · SQLBits ...
     10  +2 2014 sep 16ssas avg functionMicrosoft OLAP by Mosha Pasumansky : Moving averages in MDX"Moving average " article in Wikipedia is a good starting point to learn ... The use of MDX function Avg here is justified, because we are talking ...
     10  ~ 2014 sep 14dbforge studio3rd Party Tools: dbForge Studio for SQL Server - SQLblog.comI've been taking a look at some of the 3rd party tools for SQL Server. Today, I looked at DBForge Studio for SQL Server from the team at DevArt.
     10  +4 2014 aug 28loop sql serverBad Habits to Kick : Thinking a WHILE loop isn't a ... - SQLblog .com... is required). Sometimes the justification is that constructing a while loop is. ... using the new LAG functionality in SQL Server 2012: SELECT
     10  -2 2014 aug 16sql if existsExists Vs. Count(*) - The battle never ends... - SQLblog .comOne in particular is the use of COUNT(*) to check to see if there are any rows that match some criteria. The technique of using EXISTS over ...
     10  +9 2014 aug 09sql memory usageor Understanding SQL Server Memory Usage - SQLblog .comLearn how SQL Server allocates and uses the physical memory available on a server, as well as why SQL Server doesn't release memory like ...
     10  -4 2014 aug 03report manager ssl bindingThe Bit Bucket (Greg Low): IDisposable : Report Manager : The When I checked the SSL bindings in Reporting Services Configuration Manager , in the Advanced tab, I found that no certificate was associated ...
     10  -2 2014 aug 03backup azure databaseAutomated backups for Windows Azure SQL Database - SQLblog.comOne of the questions that I've often been asked is about how you can backup databases in Windows Azure SQL Database . What we have had ...
     10  -6 2014 jul 23pivot table web application
     10  -1 2014 jul 20sql server articlesKevin Kline : Amazingly Useful SQL Server Articles on Amazingly Useful SQL Server Articles on SQLPerformance.com. IMG_0247. Me and Aaron Bertrand, SQL Sentry flagbearers. One of the things ...
     11  +1 2014 oct 02sql audit trailCodeGen to Create Fixed Audit Trail Triggers - SQLblog .com3) A reader wrote asking for more information and advice on implementing the T- SQL dynamic audit trail trigger I wrote about in SQL Server ...
     11  +4 2014 sep 30sqlserver update setThe code below sets up a simplified example of this – a table Customers, with SSN as its .... But SQL Server 2008 will change the playing field.
     11  +3 2014 sep 29tsql updateIncrement a variable in the SET clause of an UPDATE statement [TThere's a very nifty feature of T-SQL that, in my experience, not ... of the SET clause in an UPDATE statement while updating it at the same time.
     11  +90 2014 sep 18flags in commentsDamian Widera : Trace flags - TF 7806 - SQLblog.comThe trace flag 7806 is necessary when a DBA would like to use the dedicated administrator ... Subscribe to this post's comments using RSS ...
     11  +3 2014 sep 16ssis prerequisiteJamie Thomson : SSIS Server, Catalogs, Environments In the last few days I have written 3 blog posts covering some new features in SQL Server Integration Services ( SSIS ) in the next version of SQL ...
     11  +4 2014 sep 02medical dictionary for wordJohn Paul Cook : Adding custom medical spell checking to WordOffice applications use lists of properly spelled words stored in simple Unicode text files will a file type of dic for dictionary . There is a legally ...
     11  +1 2014 aug 20temporary table in sqlTemporary Tables in Stored Procedures - SQLblog .comAsk anyone what the primary advantage of temporary tables over table ... The SQL Server query optimizer is only as good as the information it ...
     11  -1 2014 aug 17sql in a nutshellBook Review: SQL in a Nutshell - SQLblog.comWhen I opened it, I found a copy of Kevin Kline's (blog/twitter/website) latest edition of SQL in a Nutshell . I forget now exactly how the topic ...
     11  -4 2014 aug 05sql window functionsJohn Paul Cook : SQL Server 2012 Windowing Functions : LAGSQL Server 2012 introduces new windowing functions beyond the basic ranking functions of RANK, DENSE_RANK, NTILE, and ...
     11  +4 2014 jul 31sql server service packAaron Bertrand : SQL Server 2012 Service Pack 2 is available - but Service Pack 2 is available: ber is 11.0.5058, and this includes ...
     11  +3 2014 jul 23simple etl toolsKevin Kline : Is There Such a Thing as Easy ETL ? - SQLblog.comIn a situation like that, the process is so simple , all you really need to focus on ... (I also wanted to research SSIS and ETL tools for my Tool Time ...
     11  -4 2014 jul 21ms sql database replicationRob Farley - Owner/Principal with LobsterPot Solutions (a MS Gold ... In SQL Replication , the Subscribers probably have data from earlier.
     12  ~ 2014 sep 24check ssas versionDetect Tabular or Multidimensional Version in # ssas ... - SQLblog.comIf you want to detect if a particular instance of Analysis Services “Denali” is ... you can find a few instructions to detect the version by looking at the icon used. ... How to check it for SQL Server 2008 R2 in PowerShell script?
     12  +1 2014 sep 21sql dumper
     12  +6 2014 sep 21clr 06 functionT-SQL User-Defined Functions : the good, the bad ... - SQLblog.comI showed why T-SQL scalar user-defined functions are bad for performance in two previous posts. In this post, I will show that CLR scalar ...
    1 2 of 16 pages