sqlserverperformance.wordpress.com
Glenn Berry's SQL Server Performance | Semi-random musings about SQL Server performanceSemi-random musings about SQL Server performance (by Glenn Berry)
http://sqlserverperformance.wordpress.com/
Semi-random musings about SQL Server performance (by Glenn Berry)
http://sqlserverperformance.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
11
SSL
EXTERNAL LINKS
408
SITE IP
192.0.78.13
LOAD TIME
0.562 sec
SCORE
6.2
Glenn Berry's SQL Server Performance | Semi-random musings about SQL Server performance | sqlserverperformance.wordpress.com Reviews
https://sqlserverperformance.wordpress.com
Semi-random musings about SQL Server performance (by Glenn Berry)
sqlserverperformance.wordpress.com
Processor Tall Tales From Best Buy | Glenn Berry's SQL Server Performance
https://sqlserverperformance.wordpress.com/2015/02/20/processor-tall-tales-from-best-buy
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. Analyzing I/O Subsystem Performance at PASS 2014. SQL Server Diagnostic Information Queries for June 2016 →. Processor Tall Tales From Best Buy. February 20, 2015. Next, he moved on to the subject of memory. He said Windows 8 really needs at least 4GB of memory or it will really bog down. Having 6GB is better, and 8GB of memory is the best. In this guy’s defense, nothing he said was really glaringly wrong (and I have ...
Using Custom Connection Colors in SSMS | Glenn Berry's SQL Server Performance
https://sqlserverperformance.wordpress.com/2010/03/28/using-custom-connection-colors-in-ssms
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. To Get Certified or Not Get Certified. SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking! Using Custom Connection Colors in SSMS. March 28, 2010. This will make SQL Server use that custom color whether you you are opening a new connection or changing an existing connection. If you don’t set the custom color in both locations, you will probably run into issues where the color does dot a...
Fun with Extended Properties in SQL Server 2008 | Glenn Berry's SQL Server Performance
https://sqlserverperformance.wordpress.com/2011/01/10/fun-with-extended-properties-in-sql-server-2008
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. My First Sandy Bridge Desktop System. Intel Processor Information →. Fun with Extended Properties in SQL Server 2008. January 10, 2011. Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty low on my favorites list. You can also call one of three system stored procedures to manipulate your extended properties. These are:.
Handy Hardware Assessment Tools For SQL Server | Glenn Berry's SQL Server Performance
https://sqlserverperformance.wordpress.com/2010/11/15/handy-hardware-assessment-tools-for-sql-server
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. New Path to MCM in SQL Server 2008. SQL Server 2008 Service Pack 2 Cumulative Update 1 →. Handy Hardware Assessment Tools For SQL Server. November 15, 2010. Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you are interested in, whether it is a database server or a laptop. The first one is CPU-Z. Finally, we have CrystalDiskMark. You are commenting ...
SQL Server and the “Lock pages in memory” Right in Windows Server | Glenn Berry's SQL Server Performance
https://sqlserverperformance.wordpress.com/2011/02/14/sql-server-and-the-lock-pages-in-memory-right-in-windows-server
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs. Recent AMD Processor News →. SQL Server and the “Lock pages in memory” Right in Windows Server. February 14, 2011. Another Windows setting you might. Microsoft has published conflicting information about this issue over the years. The current official stance is that you should not have to use Lock pages in memory with Windows Server 2008 ...
TOTAL PAGES IN THIS WEBSITE
11
Joys With Datetimes | SQL Mate Blog
https://sqlmate.wordpress.com/2013/11/28/joys-with-datetimes
Why am I doing this? Coz I am #happy :P. T-SQL vs. MDX. My 2013 in review →. November 28, 2013. Sometimes we need to generate current timestamp in a special format (e.g. suffixes for backup files). If we are unlucky that requested format is not supported by CONVERT function and SQL Server version is 2008 R2 and older this might be a little tricky. SQL Server up to 2008 R2. This is little tricky REPLACE,REPLACE J. SQL Server 2012 and newer. This is more elegant way. Notice that I am using DATETIME2. This ...
Just in time learning: Hacking SPRoleDefinition SPRoleType in the database
http://wingleungchan.blogspot.com/2015/05/hacking-sproledefinition-sproletype-in.html
Just in time learning. Learning how to do things and fix stuff as I go because who really has time to sit in a classroom. Posting it all here because I can not remember it all. Tuesday, May 5, 2015. Hacking SPRoleDefinition SPRoleType in the database. If you are a Site Collection Administrator, SharePoint allows you to go to a Site Collection, Site Actions- Site Permissions- Permission Levels, then edit a permission level and delete it. Web = Get-SPWeb your-web-url. This gives output like the following:.
DiStas | dbadiary
https://dbadiary.wordpress.com/author/distas
Occasional notes of typical DBA day-to-day work. Quick and easy way to automate SQL Express database backups. August 6, 2015. One of free SQL Server Express limitations is the lack of SQL Server Agent and, consequently, Maintenance Plans as such. The easy way to automate regular database tasks, such as database backup would be to use internal windows scheduler and just a simple “ms dos”-like batch file. First, the backup stored procedure has to be created in [master] database. 8216;E: DBBackup’. Sysforei...
paulomatos.com: SQLSatuday#188 - Aftermath
http://www.paulomatos.com/2013/03/sqlsatuday188-aftermath.html
Ramblings about this insane world of ours. Saturday, March 23, 2013. Last weekend was another crazy weekend. Or shall I say, was the weekend of SQLSaturday#188? Some of the speakers and team. In this year edition we had five (yes 5! Simultaneous session tracks, 20 international guest speakers and 15 local and very talented speakers (thank you all, you are great)! Since I'm in the mood to keep distributing "thank yous", I need also to mention the team of volunteers, and, of course our sponsors. Sandwich, ...
MS BICOE | May 2012
http://www.msbicoe.com/2012/05/default.aspx
All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).
MS BICOE | December 2012
http://www.msbicoe.com/2012/12/default.aspx
All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).
Presenting session: Anatomy of a Join at SQL Saturday #211 in Chicago | Positively SQL
http://blog.sqlpositive.com/2013/03/presenting-session-anatomy-of-a-join-at-sql-saturday-211-in-chicago
Presenting session: Anatomy of a Join at SQL Saturday #211 in Chicago. March 27, 2013. I’m thrilled to announce that I will be presenting for the second time at SQL Saturday in Chicago my Internals session “Anatomy of a Join”. On Saturday April 13, 2013! 1221 N. Swift Rd, Addison, IL 60101. If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat211 and see what others are doing. Hope to see you there! Things to do at PASS Summit 2012.
PASS Summit | Positively SQL
http://blog.sqlpositive.com/tag/pass-summit
Tag Archives: PASS Summit. Speaking at PASS Summit 2015 in Seattle. September 6, 2015. I’m thrilled to announce that I’ll be speaking for the fourth time in a row at PASS Summit 2015 in Seattle, WA, presenting a new session , Anatomy of an optimizer. As a Regular Session on Wed 10/28/2015 starting at 4:45 pm in room 6B. I am extremely honored to be selected to speak a PASS Summit again , the greatest SQL Server conference of the year where I will join more than 150 of the industry’s leading speakers.
Chicago | Positively SQL
http://blog.sqlpositive.com/tag/chicago
Presenting to Chicago SQL Server User Group – October 9, 2014. October 8, 2014. I am honored to preview one of my sessions for PASS Summit 2014 – A Tale of Two Joins: Merge vs. Hash. To the Chicago SQL Server Users Group. At the Microsoft Technology Center, 200 East Randolph Drive, Suite 200 Chicago, IL 60601. It is a true honor to present in front of my own user group. Where I learned so much in the last 7 years. Look forward to see everyone there! March 27, 2013. On Saturday April 13, 2013!
TOTAL LINKS TO THIS WEBSITE
408
SQL Server Password - Recover, Reset and Change SQL Server Password Easily
Change, recover and reset SQL Server password easily. Login to SQL Server When Windows Account Locked Out. Admin on September 1, 2014. Can’t connect to SQL Server with Windows Authentication? Have you accidentally removed the built-in administrator account from SQL Server logins? Does the Windows account become locked and unusable for further use? Part 1: Enable Mixed Mode Authentication. Here is a simple registry trick:. Press the Windows key R to bring up the Run box. Type. Even if the authentication m...
Web Hosting - This site is temporarily unavailable
Http:/ www.fatcow.com/. Http:/ www.fatcow.com/free-icons. Http:/ www.fatcow.com/free-font. Something isn't quite right here . This site is temporarily unavailable. If you're the owner of this website,. Please contact FatCow Web Hosting.
SQLPedia
Viernes, 14 de septiembre de 2012. Screencast sobre Continuidad del Negocio en SQL Azure. Les comparto este screencast sobre opciones de continuidad del negocio en SQL Azure http:/ www.youtube.com/watch? Microsoft SQL Server MVP. Lunes, 13 de agosto de 2012. WebCast El Nuevo Mundo de la Información: SQL Server y IT Hibrido. Pueden registrarse en la siguiente dirección https:/ msevents.microsoft.com/CUI/EventDetail.aspx? Ing Eduardo Castro Martínez, PhD. Microsoft SQL Server MVP. Lunes, 16 de julio de 2012.
sqlserverperformance.blogspot.com
SQL Server Performance
It's all about SQL Server Performance Tuning and Optimizing. Large Data Operations in SQL Server. Thursday, December 7, 2006. Http:/ www.sql-server-performance.com/jc large data operations.asp. The articles in the. Quantitative Performance Analysis series. Execution Plan Cost Formula Review. I/O Cost = 0.006328500 0.000740741 per additional page. 1GB) = 0.003203425 0.000740741 per additional page ( 1GB). CPU Cost = 0.000079600 0.000001100 per additional row. I/O Cost = multiple of 0.006250000.
sqlserverperformance.idera.com
Expert advice on SQL server and SharePoint performance — Idera blog
Solutions for SQL Server. SQL Enterprise Job Manager. SQL Hekaton Memory Check. SQL Backup Status Reporter. Azure SQL Database Backup. PowerShell scripts for SQL Server. You are here: Home. The Duckiest Day of the Year. August 12, 2015. It’s Debate Season: Choosing the Best IT Ops Candidate. August 5, 2015. At the time of this writing, there are only 462 days until the next US presidential elections. So of course that means it’s debate season! August #SQLChat The Adaptive SQL Server DBA. July 29, 2015.
sqlserverperformance.wordpress.com
Glenn Berry's SQL Server Performance | Semi-random musings about SQL Server performance
Glenn Berry's SQL Server Performance. Semi-random musings about SQL Server performance. Processor Tall Tales From Best Buy. February 20, 2015. Next, he moved on to the subject of memory. He said Windows 8 really needs at least 4GB of memory or it will really bog down. Having 6GB is better, and 8GB of memory is the best. In this guy’s defense, nothing he said was really glaringly wrong (and I have heard far worse explanations of computers at Best Buy). Most of what he said was just over-simplified, pe...
sqlserverperformancemonitoring.com
SQL Server Performance Monitoring & Disk Space Management Tool
SQL Server Performance Monitoring. Manage and Increase SQL Server Performance. In the current scenario where everything is managed with computers, how do you think large bank accounts or huge organization would do without the help of these machines? Helps in setting alerts for automatic defragmentation. Allows to shrink file and file groups for better disk space. Reorganize heaps and indexes:. Enables create, switch, alter or remove partitions from tables and index levels. It eases out finding records, m...
sqlserverperformancetuning.wordpress.com
sqlserverperformancetuning | This WordPress.com site is the cat’s pajamas
This WordPress.com site is the cat’s pajamas. It seems we can’t find what you’re looking for. Perhaps searching can help. Blog at WordPress.com.
SQL Server Planet
SQL Server Hints Explained. Posted on August 6, 2015. What to do when your SQL CPU is at 100%. Posted on August 6, 2015. Convert Int to String. Posted on August 5, 2015. Export Table to CSV File – step by step. Posted on August 5, 2015. Posted on May 31, 2015. This has to be one of the most common repetitive functions needed for development. Updating a certain column in a specific table and want to find all the procedures that are affected by that? How to cache stored procedure results using a hash key.
SQL Server Platform - Microsoft SQL Server Resources and VDO Tutorials
ミネラル酵素スムージー｜増えた体重は朝食置き換えで簡単ダイエット！
SOCIAL ENGAGEMENT