sqlsailor.comSQLSailor | Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relati

sqlsailor.com Profile

sqlsailor.com

Title:SQLSailor | Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relati

Description:Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies!

Discover sqlsailor.com website stats, rating, details and status online.Use our online tools to find owner and admin contact info. Find out where is server located.Read and write reviews or vote to improve it ranking. Check alliedvsaxis duplicates with related css, domain relations, most used words, social networks references. Go to regular site

sqlsailor.com Information

Website / Domain: sqlsailor.com
HomePage size:159.072 KB
Website IP Address: 192.0.78.24
Isp Server: Automattic Inc

sqlsailor.com Ip Information

Ip Country: United States
City Name: San Francisco
Latitude: 37.748424530029
Longitude: -122.41367340088

sqlsailor.com Keywords accounting

Keyword Count

sqlsailor.com Httpheader

X-nananana: Batcache
Transfer-Encoding: chunked
Strict-Transport-Security: max-age=86400
Vary: Accept-Encoding, Cookie
X-ac: 3.sjc _bur
Server: nginx
Last-Modified: Mon, 19 Mar 2018 04:18:16 GMT
Connection: keep-alive
Link: ; rel=shortlink
Cache-Control: max-age=293, must-revalidate
Date: Mon, 19 Mar 2018 04:18:23 GMT
X-hacker: "If youre reading this, you should visit automattic.com/jobs and apply to join the fun, mention this header.", Content-Type: text/html; charset=UTF-8
Content-Encoding: gzip

sqlsailor.com Meta Info

charset="UTF-8" /
name="viewport" content="width=device-width" /
name="generator" content="WordPress.com" /
property="og:type" content="website" /
property="og:title" content="SQLSailor" /
property="og:description" content="Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies!" /
property="og:url" content="https://sqlsailor.com/" /
property="og:site_name" content="SQLSailor" /
property="og:image" content="https://secure.gravatar.com/blavatar/3c585f1a0c0fe42ca2773cf49b01ce82?s=200&ts=1521433096" /
property="og:image:width" content="200" /
property="og:image:height" content="200" /
property="og:locale" content="en_US" /
name="twitter:site" content="@wordpressdotcom" /
name="application-name" content="SQLSailor" /
name="msapplication-window" content="width=device-width;height=device-height" /
name="msapplication-tooltip" content="Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies!" /
name="msapplication-task" content="name=Subscribe;action-uri=https://sqlsailor.com/feed/;icon-uri=https://secure.gravatar.com/blavatar/3c585f1a0c0fe42ca2773cf49b01ce82?s=16" /
name="msapplication-task" content="name=Sign up for a free blog;action-uri=http://wordpress.com/signup/;icon-uri=https://s2.wp.com/i/favicon.ico" /
name="msapplication-task" content="name=WordPress.com Support;action-uri=http://support.wordpress.com/;icon-uri=https://s2.wp.com/i/favicon.ico" /
name="msapplication-task" content="name=WordPress.com Forums;action-uri=http://forums.wordpress.com/;icon-uri=https://s2.wp.com/i/favicon.ico" /
name="title" content="SQLSailor on WordPress.com" /
name="description" content="Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies!" /

192.0.78.24 Domains

Domain WebSite Title
madamenoire.comMadameNoire | Black Women's Lifestyle Guide | Black
rispca.comAdoptable Dogs – Rhode Island SPCA
postsecret.comPostSecret
lakelandhighschool.comHome of the Dreadnaughts! – Believe-Achieve-Succeed
jazzinlondon.livejazzlondonlive
regimental-standard.comThe Regimental Standard – Required weekly reading for
thegraycanary.comThe Gray Canary
1015soul.com101.5 Soul
sttheresachurch.orgSt. Theresa Parish
selvedgeyard.comThe Selvedge Yard | A historical record of artistry

sqlsailor.com Similar Website

Domain WebSite Title

sqlsailor.com Traffic Sources Chart

sqlsailor.com Alexa Rank History Chart

sqlsailor.com aleax

sqlsailor.com Html To Plain Text

SQLSailor | Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies! SQLSailor Personal Notes on Microsoft SQL Server,AWS,Microsoft Azure and Emerging Relational Database Technologies! Menu Skip to content Home About Photography Specialization and Certifications Post navigation ← Older posts SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks Posted on February 22, 2018 by AnupWarrier I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017 running on a docker container, and run it locally within the Mac. In this post I will discuss some tips and tricks which will come handy if you are interested to pursue this route. Tip 1 : How do I install SQL Server on a Mac? You can follow the below steps to get started. Get docker Docker pull sudo docker pull microsoft/mssql-server-linux:2017-latest Docker run sudo docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' \ -p 1401:1433 --name containername -d microsoft/mssql-server-linux:2017-latest Tip 2 : How to connect to the SQL instance running on a container via SQL Operations Studio? Get SQL Operations Studio Get your Mac IP using ifconfig Use SQL Operations Studio to connect to the instance using the IP Tip 3 : How to view the running containers? Run docker ps docker ps Tip 4 : How to stop the running container? docker stop Tip 5 : How to view the details of containers which are in stopped state? docker ps -a Tip 6 : How to connect to the SQL instance running on a container via command line? Run the below sqlcmd command – sqlcmd -S YourIP,Port -U SA -P '' You can issue regular T-SQL commands after you establish the connection. Tip 7 : How to persist data ? If you remove the container, the entire database which you might have configured is lost. To avoid this, you can create a data volume container. Below is the command to create container with a data volume with name sqlvolume – docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=ReallyStrongPassword' -p 1433:1433 --name containername -v sqlvolume:/var/opt/mssql -d microsoft/mssql-server-linux:2017-latest The databases which you create will now be persisted until you delete the volume. Tip 8 : How to share the data volume container with multiple containers ? If you stop an existing container which is using the data volume,then you can create another container with the same data volume name and databases which were hosted under the data volume will reflect under the new container. Conclusion: The ability to spin up and spin down containers and multiple containers is changing the way I test various versions of SQL Server/Databases and its super flexible when it comes to a CI/CD pipeline. Thanks for reading, and keep watching this space for more. Advertisements Share this: Tweet Print Email Like this: Like Loading... Posted in Containers , SQL2017 | Tagged Mac , SQL2017 | Leave a comment SQL Server 2017 running on Windows Containers! Posted on May 9, 2017 by AnupWarrier One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on containers? Here is what Microsoft has to say: “Windows Containers are an isolated, resource controlled, and portable operating environment. An application inside a container can run without affecting the rest of the system and vice versa. This isolation makes SQL Server in a Windows Container ideal for Rapid Test Deployment scenarios as well as Continuous Integration Processes.” Recently I had a chance to invest sometime configuring SQL Server 2017( CTP 2 ) on Windows Containers, and this post will give you the step by step instructions on how to configure this. Step 1 – Choose Windows Server 2016 for running containers. All my testing was done in AWS, and I picked the below AMI- Microsoft Windows Server 2016 Base with Containers Step 2 – Install Docker. Run the below PS commands – Install - Module - Name DockerMsftProvider -Repository PSGallery - Force Install - Package - Name docker -ProviderName DockerMsftProvider Start-Service Docker Step 3 – Update Windows Patches. Step 4 – Do docker pull to get the Official images for Microsoft SQL Server for Windows Containers. docker pull microsoft/mssql-server-windows Step 5 – Run the container. docker run -d -p 1433:1433 -e sa_password= -e ACCEPT_EULA=Y microsoft/mssql-server-windows Step 6 – Run docker ps and note down the container_ID. Run docker inspect and note down the IP of the container. docker inspect --format='{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' Step 7 – Connect to the SQL Server(Instance) outside the container via SQL Server Management Studio. Use the IP to connect. *Click on the image below for better resolution. Conclusion : That’s pretty much it. Within 7 steps you are running SQL Server 2017 on Windows Containers. Its super lightweight and easy to spin up. Perfect fit for a CI pipeline. Thanks for reading, and keep watching this space for more(container goodness!). Share this: Tweet Print Email Like this: Like Loading... Posted in Containers , Docker , SQL Server 2017 , SQL2017 | Tagged Containers , Docker , SQL2017 | Leave a comment Google Cloud Spanner – Next big thing in the database world? Posted on March 13, 2017 by AnupWarrier Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this since it’s a big news! So, what exactly is Cloud Spanner and why it’s a big deal? Here is how Google Summarizes its importance: “A globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability.” As per Google, Cloud Spanner is a No-Compromise Relational Database Service and it is the first and only relational database service that is both strongly consistent and horizontally scalable. With Cloud Spanner you enjoy all the traditional benefits of a relational database: ACID transactions, relational schemas (and schema changes without downtime), SQL queries, high performance, and high availability. But unlike any other relational database service, Cloud Spanner scales horizontally, to hundreds or thousands of servers , so it can handle the highest of transactional workloads. With automatic scaling, synchronous data replication, and node redundancy, Cloud Spanner delivers up to 99.999% (five 9s) of availability for mission critical applications. I’m really excited about Cloud Spanner because it’s been used/tested within Google heavily, and they had published a paper about it in 2012. It’s time to spin this up, and get hands dirty. If you would like to know more about Cloud Spanner, then please access the below links – https://cloud.google.com/spanner/ https://cloudplatform.googleblog.com/2017/02/introducing-Cloud-Spanner-a-global-database-service-for-mission-critical-applications.html https://static.googleusercontent.com/media/research.google.com/en//archive/spanner-osdi2012.pdf https://research.google.com/archive/spanner.html Thanks for reading and keep watching this space for more! Advertisements Share this: Tweet Print Email Like this: Like Loading... Posted in GoogleCloud | Tagged CloudSpanner , GoogleCloud , Relational | Leave a comment Windows Server 2016 and SQL Server 2016 – A match made in heaven! Posted on December 22, 2016 by AnupWarrier For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016, you can now create a Windows Cluster with nodes in multiple domains. Or even without a domain (Workgroup). With Windows Server 2016 and SQL Server 2016, you can now create an Always On Availability Group configuration with nodes in multiple domain, and this is exactly why I’m super exci...

sqlsailor.com Whois

"updated_date": "2017-11-29 07:34:34", "status": [ "clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited", "clientRenewProhibited https://icann.org/epp#clientRenewProhibited", "clientTransferProhibited https://icann.org/epp#clientTransferProhibited", "clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited" ], "name": "Registration Private", "dnssec": "unsigned", "city": null, "expiration_date": "2018-12-30 19:57:07", "zipcode": null, "domain_name": "SQLSAILOR.COM", "country": null, "whois_server": "whois.wildwestdomains.com", "state": null, "registrar": "Wild West Domains, LLC", "referral_url": null, "address": null, "name_servers": [ "NS1.WORDPRESS.COM", "NS2.WORDPRESS.COM" ], "org": "Domains By Proxy, LLC", "creation_date": "2011-12-30 19:57:07", "emails": "abuse@wildwestdomains.com"