Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Savra, our new database engineer needs to check existence of a certain keyword on the database. So she went for it… Command: Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Command: SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update, * FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID(‘[replace with your database name]’) AND OBJECT_ID = OBJECT_ID(‘[replace with your table name]’) Steps and Sample Usage: Open and log into your SQL Management Studio Open a New
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Command: SELECT d.*, p.* FROM [AdventureWorks2016].[HumanResources].[Department] d JOIN [AdventureWorks2016].[Person].[Person] p ON 1 = 1 Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or (CTRL+N) Run the following commands: (Copy and Paste the code block to your Query Window)
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) If you are an Database Administrator chances are you’ve came across few request adding new users to the database, aside, the company should have stricter rules implementing security across the organization as such keeping passwords up to date and adherence
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) As a Database Administrator, I’m always a fan of CLI (Command-Line Interface) to run some adhoc administrative commands in administering Microsoft SQL Server and Database. In my case I often use osql or sqlcmd. SQL CLI osql allows you to enter and run Transact-SQL statements, system procedures,
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Although, you can generate table scripts easily using built-in context menu from SQL Database Management Studio, you may want to do it your own way.. the HARD way but FUN way. In this post, we will do that, we will extract the table definition of our database
Please read our Disclaimer Works With-Windows 10 Version 1903 OS Build 18362.836 There are times when you need to generate an MD5 to know if something you’ve downloaded from the internet was not altered from the original. MD5, being one of the most commonly used cryptographic hash function has its own throes and limitations. Nevertheless, having the tools will always