solidq.com
High Availability, Disaster Recovery and Virtualization | SolidQ Worldwide
http://www.solidq.com/consulting/data-management/high-availability-disaster-recovery-virtualization
Global - ( 34) 91 414 89 50 N. America - (800) 757 6543. Spain, Portugal & Latam. BI & Analytics. Analytics & Data Science. High Availability, Disaster Recovery & Virtualization. Performance Tuning & Database Optimization. SQL Server Upgrade & Cloud Strategies. Solution Architecture & Scalability. Architecture & Design. DW Generation (or ETL). Books & Publications. HIGH AVAILABILITY, DISASTER RECOVERY AND VIRTUALIZATION. Data Management (SQL Server). Contact us to learn more. Books & Publications. German...
solidq.com
Cart | SolidQ Worldwide
http://www.solidq.com/cart
Global - ( 34) 91 414 89 50 N. America - (800) 757 6543. Spain, Portugal & Latam. BI & Analytics. Analytics & Data Science. High Availability, Disaster Recovery & Virtualization. Performance Tuning & Database Optimization. SQL Server Upgrade & Cloud Strategies. Solution Architecture & Scalability. Architecture & Design. DW Generation (or ETL). Books & Publications. Your basket is currently empty. Join Microsoft & SolidQ for a full day of SQL Modernization and Advanced Analytics. Books & Publications.
solidq.com
Big Data | SolidQ Worldwide
http://www.solidq.com/consulting/business-analytics/big-data
Global - ( 34) 91 414 89 50 N. America - (800) 757 6543. Spain, Portugal & Latam. BI & Analytics. Analytics & Data Science. High Availability, Disaster Recovery & Virtualization. Performance Tuning & Database Optimization. SQL Server Upgrade & Cloud Strategies. Solution Architecture & Scalability. Architecture & Design. DW Generation (or ETL). Books & Publications. Big Data demands a new approach on analysis. Big Data demands fast processing. Big Data demands new data storage solutions. As it has a prove...
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: January 2015
http://sqlserveradmin.blogspot.com/2015_01_01_archive.html
Microsoft SQL Server Administrator. Friday, January 9, 2015. In this post I will show how to use sys.dm io virtual file stats to collect I/O statistics over a sertain time. There are many good information written about this DMV but I have not seen any easy one about how to collect and analyse data from the DMV over time. I will show one way I often use. The post is written with inspiration from Paul Randals excelent article. But I have done some change to fit my needs. Database id] [smallint] NOT NULL,.
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: March 2013
http://sqlserveradmin.blogspot.com/2013_03_01_archive.html
Microsoft SQL Server Administrator. Tuesday, March 26, 2013. Windowing functions - stochastic oscillator. Last time I was looking on the calculation of simple moving average using the new windowing features in transact SQL. I was curious how to do some deeper calculation in the stock analysis area. So today I shall see how we calculate the Stockhastic oscillator. This function use two inputs. D% and K% and the formula are:. K = 100*(C - L14)/(H14 - L14). C = the most recent closing price. There were some...
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: November 2014
http://sqlserveradmin.blogspot.com/2014_11_01_archive.html
Microsoft SQL Server Administrator. Monday, November 24, 2014. How to know if an index is compressed. In management studio you can see if a table is compresed by just chose properties on it. But why is it not the same for index? Something that would be nice as I see it. Anyway, we can use some code to find it out. Bobject id = a.object id AND. Bindex id = a.index id WHERE. Subscribe to: Posts (Atom). Im Joel and I live in Växjö. How to know if an index is compressed.
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: August 2015
http://sqlserveradmin.blogspot.com/2015_08_01_archive.html
Microsoft SQL Server Administrator. Tuesday, August 4, 2015. Partitioning and simple partitioning switching. Partitioning in SQL server. Datum] [datetime] NULL,. Datum] [datetime] NULL,. Create the filegroups- - - - - - - - - - - -. Setup the files, one on each filegroup- - - - - -. N'C: Program Files Microsoft SQL Server MSSQL11.MSSQLSERVER MSSQL DATA TestPartition1.ndf'. N'C: Program Files Microsoft SQL Server MSSQL11.MSSQLSERVER MSSQL DATA TestPartition2.ndf'. Msg 4904, Level 16, State 1, Line 106.
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: November 2012
http://sqlserveradmin.blogspot.com/2012_11_01_archive.html
Microsoft SQL Server Administrator. Wednesday, November 14, 2012. How to switch cluster nodes in Windows 2003 with SQL 2005 installed. This is not the most modern products anymore. Anyway I went in to a problem where we were forced to switch the old server to new one. If some of you out there need to do it I describe the steps here. Not in detail but some aspect to think about. Install same SQL servicepack and patches as the old servers. Run also those from the active cluster node. Unable to load user-sp...
sqlserveradmin.blogspot.com
Microsoft SQL Server Administrator: February 2013
http://sqlserveradmin.blogspot.com/2013_02_01_archive.html
Microsoft SQL Server Administrator. Monday, February 4, 2013. Play around with new windowing functions. Im not an developer but off courseI like to try new features and get knowledge in the transact language anyway. I have been interested in stocks for many years and was playing around with Excel to do some simple classic stock analysis. Then it come to my mind if these calculations is possible direct in SQL. How can we use the new windowing function in transact then? Here is an example:. On this blogg I...
SOCIAL ENGAGEMENT