Skip to content
Monday, May 23, 2022

Ramblings of a Crafty DBA

  • Home
  • About John

Tag: CREATE LOGIN

Transferring Logins Between Servers

January 12, 2014April 20, 2016 admin

There are two main categories of logins in SQL Server. There are WINDOWS logins in which password restrictions are controlled by the Active Directory (AD) policy. Then there are SQL logins in which the database administrator has more control. Lately, I have been crafting new database servers with the latest hardware to make sure my organization is ready for growth during the next five years. This includes installing the current version of SQL Server and migrating all the applications from the old server to the new server. In short, transferring…

Database AdminCREATE LOGIN, database administrator, free code, John F. Miner III, SQL Login, transfer logins, TSQL, WINDOWS loginLeave a comment

Managing Azure via SSMS

March 6, 2013October 8, 2017 admin

I recently presented at SQL Saturday 184 in North Haven and was able to listen to Grant Fritchey’s present “Query Tuning in the Clouds”. What I got out of the presentation was the sense all your tuning skills could be used to optimize a Windows Azure SQL database. I knew Windows Azure SQL Databases have been around for a couple of years but never had the time or need to research them. With a possible data center consolidation in the future, I was wondering if my company could leverage a…

Database AdminALTER TABLE, Azure SQL Database, cloud computing, create function, CREATE INDEX, CREATE LOGIN, create procedure, CREATE TABLE, CREATE USER, create view, database administration, Free Azure Computing, John F. Miner III, MSDN Benefits, SSMS., Windows AzureLeave a comment

User Design with SSMS

February 1, 2013February 6, 2013 admin

Most of the articles that I presented so far for database development have been centered around the exact Microsoft T-SQL syntax to perform a certain operation. At the University of Rhode Island, I learnt how to program in Pascal before typing in my first ANSI SQL statement. In short, I will always be some type of developer in my heart. However, many people do not come from a computer science and math background. The SQL Server Management Studio (SSMS) has menus and dialog boxes to achieve many of the same…

Database DeveloperCREATE LOGIN, CREATE USER, DDL, Designing users, DROP LOGIN, DROP USER, free code, John F. Miner III, Principles, Securables, SQL Server, SQL Server Management Studio, SSMS.Leave a comment

Crafting Databases – Part 2

August 22, 2011August 22, 2011 admin

The CREATE LOGIN and CREATE USER statements are part of the Data Definition Language (DDL) defined by Codd. Basically, a server login has to be defined so that person can connect to the server and a user login has to be created to map the server login to a particular database. I am going to continue my talk with the BSA hypothetical business problem from Part 1. Server logins allow access at the server level which can be defined using Windows Authentication or a SQL Server Authentication. Windows Authentication assumes…

Database DeveloperALTER LOGIN, ALTER USER, CREATE LOGIN, CREATE USER, database developer, DROP LOGIN, DROP USER, free code, John F. Miner III, SQL Server, TSQL2 Comments

Search Site

Categories

  • Database Admin (43)
  • Database Developer (81)
  • Integration Services (5)
  • Other (15)
  • Perl Scripting (7)
  • Power BI (4)
  • PowerShell (2)
  • Presentations (66)
  • SQL Tidbits (101)
  • VB Script (10)

Archives

Calendar

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Jun    

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Crafty Dba © 2016

Proudly powered by WordPress | Theme: AcmeBlog by Acme Themes